So I needed to use another character – such as pipe (“|”). Additionally, I couldn’t wrap the values inside quotes due to limitations in both the export and the import functionality.
However, this time I was posed with an issue: the data included both commas (“,”) and semicolons (“ ”), both of which are typical delimiters in CSV files. Normally, that’s simple – just “save as” with a different file format. The use of the comma as a field separator (Delimiter) is the source of the name for this file format. Each record consists of one or more fields, separated by commas. What’s a “CSV” -file ? Stands for “comma-separated values” – A text file that uses a comma to separate values.Įach line of the file is a data record.
Which brought me into the beautiful world of CSV delimiter configuration in Windows. xlsx file into another form, that another application could read. If you’re still here, let’s delve into the background of the issue a bit deeper.
0 kommentar(er)
