G
Guest
I have a csv file
apx 500 fields in double quotes, separated by commas. Each "value" mwill
vary in length
There may be many rows of data like this in the file, each with the same
number of values
Blank values are represented by 2 double quotes
Example:
"Name","Address","Phone","Gender",etc.etc.etc.etc
"Mary","123 Any Street","555-1212","F"
"Bill","PO Box 1","","M"
"Darth","","",""
What I want to do is bring in each field from row 1 and put it in a
spreadsheet going down say 500 rows in column A.
Then move to the next data row and insert each of those fields into column B.
Like this:
"Mary"
"123 Any Street"
"555-1212"
"F"
etc etc etc etc
I know READLINE will read a whole line, but I haven't found a way to read a
"value".
Any ideas?
apx 500 fields in double quotes, separated by commas. Each "value" mwill
vary in length
There may be many rows of data like this in the file, each with the same
number of values
Blank values are represented by 2 double quotes
Example:
"Name","Address","Phone","Gender",etc.etc.etc.etc
"Mary","123 Any Street","555-1212","F"
"Bill","PO Box 1","","M"
"Darth","","",""
What I want to do is bring in each field from row 1 and put it in a
spreadsheet going down say 500 rows in column A.
Then move to the next data row and insert each of those fields into column B.
Like this:
"Mary"
"123 Any Street"
"555-1212"
"F"
etc etc etc etc
I know READLINE will read a whole line, but I haven't found a way to read a
"value".
Any ideas?