Using regular expressions to remove text

vandadm · Newbie Joined: 18 May 2012 Posts: 1

Hello.

I'm having an issue regarding using regular expressions to find and remove text.

I have a spreadsheet with a lot of HTML code in the cells. I'd like to remove all of the HTML code, but also some of the text in between certain tags.

For example, I'd like to remove all text in between <ul> and </ul> tags in my spreadsheet, including the HTML tags themselves.

Where I'm completely lost is how to set up the search to actually find all the text.

Any help would be most appreciated. Thanks!

vandadm

probe1 · Posted: Fri May 18, 2012 7:25 pm Post subject:

Welcome to the forum

SEARCH <ul>.*</ul>

REPLACE with nothing (leave empty), check regular expression.

Does this help?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs

Villeroy · Posted: Sat May 19, 2012 5:04 am Post subject:

To eliminate the remaining tags, you can load the html in a browser and copy the resulting text from there.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org