Remove Style Tags From HTML using Find & Replace

Discuss the spreadsheet application
Post Reply
digitalmedium
Posts: 2
Joined: Tue Dec 06, 2016 2:50 pm

Remove Style Tags From HTML using Find & Replace

Post by digitalmedium »

Hi There,

I have a CSV file which includes some HTML content such as this <span style="color: #ff0000; font-size: large;"><span style="text-decoration: underline;">. I would like to actually keep the html tags but there are style tags within these HTML tags which will affect how the content will look when I go to import it on my website. I want to do a find and replace and remove the style tags from the html. So then I would just be left with <span> and the CSS of the website would then style it as it should be rather than use the style from the html.

I just need to work out the right Regular Expression that I need to use. Any suggestions?

Thanks,

Jonathan
OpenOffice 4.1.12 on Windows 10
User avatar
Lupp
Volunteer
Posts: 3549
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Remove Style Tags From HTML using Find & Replace

Post by Lupp »

Use 'Find & Replace' as demonstrated in the attached example.

Edit: There was a technical problem with my fingertips obviously. New upload resulted in two identical attachments. I'll leave it to that.
Attachments
aoo86398RemoveSpecificPartOfText_1.ods
(36.3 KiB) Downloaded 122 times
aoo86398RemoveSpecificPartOfText_1.ods
(36.3 KiB) Downloaded 85 times
Last edited by Lupp on Tue Dec 06, 2016 3:56 pm, edited 3 times in total.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
digitalmedium
Posts: 2
Joined: Tue Dec 06, 2016 2:50 pm

Re: Remove Style Tags From HTML using Find & Replace

Post by digitalmedium »

Hi Lupp,

I don't see an attached example?

Thanks,

Jonathan
OpenOffice 4.1.12 on Windows 10
Post Reply