I open a CSV file with LibreOffice Spreadsheet. I need to narrow down the data based on some constraints. I am wondering whether it is possible to run SQL queries like things on the file. If yes, I will save a lot of time for the task. The query would be something like
"select * from <> where = ‘something’ "
Yes, you are absolutely right - a correctly written query will return the required set of data almost instantly. If you know how to write SELECT (and you really know, I see it), use the BASE component instead of the CALC. Just when creating a database, indicate that you want to connect to an existing database and select Text. Further - simply