Delete cell content in Libre (Open) Office based on the cell value

Question

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but it doesn't support neither UTF-8 nor macros for advanced filtering.

So, there are 4 columns, 3 of which contain numbers (with decimal numbers) and 1 of which contains text.

I'm trying to find a way to delete rows with a macro code. I can achieve the desired behavior with filters too, but it's annoying to type all of the filtering values over and over again and there doesn't seem to be a way to export the filter and us it repeatedly.

These rows should be deleted:

1. The ones that don't contain certain words in textual column (column A). There are a few thousand different words used in that column and I want to keep only the rows that contain one of about 30 words in that column.

2. Additionally, the number is the other columns should be bigger than 3.8 (column B), 4.5 (column C) and smaller than 20 (column C).

The row-deletion type is "Shift up".

Hopefully I have explained it well. Thanks a lot in advance for your help!

Answer 1

I realize this isn't answering your question, and OOcalc is a great tool, but perhaps you didn't look at CSVfix? definitely a "proper CSV editor" IMO, just not a GUI tool; it works from the console. However this makes it easy to script your parameters into batch files for regular re-use, and it supports regular expressions and numeric ranges for both include and exclude operations.