Andre Garzia has given a nice tutorial of importing data from a Google Sheets here:
https://andregarzia.com/2018/11/reading ... ecode.html
Works nicely by exporting the sheet as (the dreaded) CSV. You can download the demo stack and try it. My problem is that my data has carriage returns inside the cells (e.g. by pressing command return on Mac). This messes up the data (not surprisingly).
I have created a minimal sheet here:
https://docs.google.com/spreadsheets/d/ ... edit#gid=0
that is visible by anyone. When I use Andre's method, the returns are mixed with the returns in the sheet. So I thought a tab separated output might solve it (.tsv). Indeed manually downloading the tsv results in a pretty clean file and I think it keeps all the data nicely. I modified the stack (attached) by putting a button and changing all "csv" to "tsv". In particular, in the url to fetch, I changed:
Code: Select all
...tqx=out:csv...
Code: Select all
...tqx=out:tsv...
Can anyone help me get clean data into LiveCode? thanks.