Ask Your Question

[Calc]How to remove HTML tags and their contents in a CSV using Find & Replace? [closed]

asked 2014-06-21 22:05:03 +0100

Ktech gravatar image

I was able to find a simple Find and Replace Regex for Excel that removed all the HTML from an exported .CSV, BUT have had no luck finding anything similar for LibreOffice. I need to be able to select all, do a find and replace using something like <*> to replace all the

  • ,etc etc. with a space. This is because the product descriptions in one of the cells are going to be pasted in plain text. Basically I want anything that is surrounded by "< >" to be replaced with a space. Will save me hours of time. Hope someone can help. I have searched a lot trust me this was my last resort. Thank you.

  • edit retag flag offensive reopen merge delete

    Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
    close date 2016-02-25 22:20:43.529545

    1 Answer

    Sort by » oldest newest most voted

    answered 2014-06-21 23:27:34 +0100

    m.a.riosv gravatar image

    LibreOffice has a built in Regex engine. From 4.0 the ICU regular expression engine instead of a custom version.

    edit flag offensive delete link more

    Question Tools

    1 follower


    Asked: 2014-06-21 22:05:03 +0100

    Seen: 1,712 times

    Last updated: Jun 21 '14