What is a (better) replacement for CSV-data?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
-
- Posts: 37
- Joined: Mon Nov 16, 2020 8:16 pm
What is a (better) replacement for CSV-data?
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?
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?
Re: What is a (better) replacement for CSV-data?
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
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
-
- VIP Livecode Opensource Backer
- Posts: 9660
- Joined: Wed May 06, 2009 2:28 pm
- Location: New York, NY
Re: What is a (better) replacement for CSV-data?
@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
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
-
- VIP Livecode Opensource Backer
- Posts: 9660
- Joined: Wed May 06, 2009 2:28 pm
- Location: New York, NY
Re: What is a (better) replacement for CSV-data?
Bogs.
You must have meant "annoyed" not "employed".
Craig
You must have meant "annoyed" not "employed".
Craig
Re: What is a (better) replacement for CSV-data?
Employed to be a noid ....HEY, THATS MY JOB!!!