Hello I have 2 versions of a txt file that I need to convert to calc. I don't care which version I use as I can create either one for my needs. First one is the exportfile.txt this has no headers but I need them to be there, second one reports.txt has all the info there but I need it on two rows.
My overall goals with this is.
1. convert the txt file to spread sheet with headers and info for a csv file import.
2. is have this done as a form of a script to be done behind the scenes after a triggered like event.
Any ideas or help much appriciated
txt file import help
txt file import help
Last edited by RusselB on Wed Feb 12, 2020 12:01 am, edited 1 time in total.
Reason: Post moved from Calc as the OP is requesting a script
Reason: Post moved from Calc as the OP is requesting a script
open office 4 windows 7, 10
Re: txt file import help
There are lots of results for importing CSV files here if you do a search. eg
viewtopic.php?f=5&t=100001
viewtopic.php?f=5&t=100001
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)