What is a (better) replacement for CSV-data?

[Francesco77]

For my first LC-project I need a lot of data in form of vocabulary items etc.

I started to collect these data in MS-Excel which is quite convenient for gathering big amounts of data.
I then export these data in CSV-format and import it into LiveCode.

When learning how to do this I read a lot about the csv-format being obsolet and that it should not be used if possible.
Someone in this forum compared the csv-format with polio which should be eradicated

Since I do not know much about data-formats, data tables or data grids I have no idea which data-format would be better than CSV.

Which other format is recommended for the use with LiveCode?

[Klaus]

Buonasera Francesco,

here a good read and a CLEVER script to overcome some inconveniences of Csv:
https://www.fourthworld.com/embassy/art ... t-die.html

The best thing is to use CSV but actually saved as TSV (TABULATOR separated values).


Best

Klaus

[dunbarx]

@Francesco

Hi.

What Klaus said.

CSV is problematic because commas are common characters in any dataSet, and you do not want common characters to be your delimiters. I never allow them.

Can't you keep and export your data from Excel as Tab and Return delimited text? This is what Klaus was recommending. Why, unless your data comes from another source that way, do you ever need to use CSV? And if it does, immediately replace every comma with tab.

@The whole world. Anyone have a valid reason to prefer CSV, even if you have to read data in that format?

Craig

[SparkOut]

@The whole world. Anyone have a valid reason to prefer CSV...?

Some people may have "reasons" but none of those are valid.

[bogs]

@The whole world. Anyone have a valid reason to prefer CSV, even if you have to read data in that format?

Well, I imagine it keeping someone employed might be a valid reason

[dunbarx]

Bogs.

You must have meant "annoyed" not "employed".

Craig

[bogs]

Employed to be a noid ....HEY, THATS MY JOB!!!