Ask Your Question
0

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

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

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

or
  • ,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
    0

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

    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.

    https://help.libreoffice.org/scalc/sv...

    https://help.libreoffice.org/Common/L...

    edit flag offensive delete link more

    Question Tools

    1 follower

    Stats

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

    Seen: 1,834 times

    Last updated: Jun 21 '14