Hi,
Apologies for what may be a total noob question. I have searched this forum and others for answers to this and I am getting desperate. Thanks.
I am importing data from a live google sheets page into my app via a CSV file. I basically just add the URL https://docs.google.com/spreadsheets/d/.../export?format=csv to the properties of the web object and then “call web1.get” the read the table.
It reads the table just fine. I then use a “list from CSV table” to assign the records to a list.
My problem is that the “list from CSV table” call seems to strip out all the commas between the fields and it adds parentheses to the front and back of each record.
For example:
abc, 123, xyz, 789
def, 456, tuv, 456
becomes:
(abc 123 xyz 789)
(def 456 tuv 456)
I need the commas to parse out the fields in subsequent code. I can’t use the spaces because some fields may contain spaces. And the parentheses are just plain annoying.
Any advice would be gratefully accepted. Thanks.