Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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,,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