Find and Replace in Calc - HTML and line breaks

[krevin_latt]

Hi, Hope someone can help.
I need to do a find and replace in calc on some HTML. The HTML is formatted with line breaks.
I need to replace the following

</p>

</div>

<!-- IMAGE WARNING BOX -->

with

</p>
</div>
</div>

<!-- IMAGE WARNING BOX -->

Essentially, I am inserting an extra </div>, but I can’t get F&R to find the text.
</p></div><!-- IMAGE WARNING BOX --> is not finding anything. Is there a character I need to insert in F&R to show a line break? Any pointers would be greatly appreciated.

[JohnSUN]

Just one question - why Calc? Why, for example, not Notepad++?

[Grantler]

@krevin_latt

Essentially, I am inserting an extra </div>, but I can’t get F&R to find the text.

Try out:
<\/div>
You have to mask some special characters/operators.
See: Regular Expressions - ICU Documentation

JohnSUN wrote:
Just one question - why Calc? Why, for example, not Notepad++?
Good question! +1

[krevin_latt]

The Calc file is a CSV from Magento. It’s a spreadsheet of products, each with product description written in HTML. In order for Ebay not to insert any silly business, it has to be formatted. I’m just going with what I know. Am I able to do this in Notepad ++ ?

[Grantler]

Sample files (csv; target format) could be helpful…

[JohnSUN]

A comma-separated values (CSV) file is a delimited text file (Wiki)

This means that it can be changed in any text editor. Yes, Notepad++ is one of many text editors.

[krevin_latt]

There we go, I have a try in Notepad ++ and see if that does the trick. Thank you.