There’s a CSV file I’m trying to edit with Calc, in notepad it uses a tiny nubby right arrow as it’s text delimiter. I’ve been told that’s a tab so I told LibreOffice to use {Tab} as the text delimiter. The symbol is not present in the modified file and the javascript program that extracts data from the file freezes and throws up “warn: language data lacking”. What to do? It is impossible for me to copy or paste the symbol directly. Version: 5.3.3.2 (x64) Win7.
What are you doing after you have edited the csv file? How do you save the result of your edit? For me your question looks like you didn’t save using Save As and option Edit filter settings to assure that {Tab} is set in Field Options as Field delimiter
I’ve been using Save As, Edit filter settings, and using {Tab} for Text delimiter. I tried Field delimiter, same result and file appears strange in notepad with that setting. Field delimiter was already set to comma.
I’ve also noticed that the file size of the CSV file shrunk by about 5% after changing no data.
Ok - the issue must be with I’ve been told… needs to be extended with probably not the full truth.. Seriously, it’s hard to analyze the real issue without the original file, since it looks you made everything correct when saving the final result.
I looked at the sample file using a hex editor and find that it uses the comma - ASCII code 44 decimal or 2C hex - as the text delimiter. It has 21 fields and 3142 records.
Opening the file in Notepad I see the normal comma.