Search found 3 matches

by Mharvey500
Sat Mar 21, 2020 3:09 am
Forum: Development, plugins and third party software
Topic: CSV Viewer/Editor - Searching CSV like Everything Search
Replies: 23
Views: 92527

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Referring to https://ask.libreoffice.org/en/question/144942/how-to-convert-to-csv-with-utf-8-encoding-using-lo5-command-line/?answer=144958#post-id-144958 I had success producing a tab separated UTF-8 encoded file with, "C:\Program Files\LibreOffice\program\soffice.exe" --headless --convert-to csv:"...
by Mharvey500
Sat Feb 29, 2020 2:43 pm
Forum: Development, plugins and third party software
Topic: CSV Viewer/Editor - Searching CSV like Everything Search
Replies: 23
Views: 92527

Re: CSV Viewer/Editor - Searching CSV like Everything Search

Thanks for the info. I was able to get gawk to search a tab separated file very quickly, much quicker than PowerShell.
"gawk -F $'\t'"
Do you know how to script LibreOffice to save or export an ods file to csv or tsv from command line?
by Mharvey500
Sun Feb 09, 2020 5:44 pm
Forum: Development, plugins and third party software
Topic: CSV Viewer/Editor - Searching CSV like Everything Search
Replies: 23
Views: 92527

Re: CSV Viewer/Editor - Searching CSV like Everything Search

What I need is a command line tool that searches a CSV file for lines that match a key to a specific field in the line, e.g. name or address, etc. This is needed for Windows but it would be nice to have it on Linux. I currently have my data in a LibreOffice spreadsheet and I export it to CSV, then I...