[REBOL] csv file reading
From: jblake:arsenaldigital at: 31-Jan-2008 11:27
I have a Rebol utility that will read a csv file and open tickets with
the info.
Works like a champ. Or should I say "worked". The last field is a
comment field.
In the recent csv, the comment was actually a e-mail that had been put
in the field. Rebol normally reads line till the newline. Well the
e-mail has a bunch of newlines in it so if I look at the file on
NotePad, it sees all of them and shows new lines. This is causing Rebol
to think each line of the mail should be used to open a ticket which is
not going to work.
Has anyone come up with a way to deal with multiline fields in a csv?
For example,
You have 5 fields.
Customer,server,contact,phone,comment
The data is
Bill,Bilbo,bill-yahoo.com,555-555-5555, Please open a ticket for this
server
That is correct.
But if they put say 5 lines of text in the comment field, how do we
deal with that?
I'm currently using [,"] for delimiters because excel will auto put in
the " if it needs to.
Ideas?
I'm searching the archives for info.
Thanks
John