How about getting one row at a time (using chr(13) as a delimiter, say), then
using comma-delimiting within that string?
Or just replace(variable, "#chr(13)##chr(10)#",",","ALL")
David Cummins
Douglas Jordon wrote:
>
> I'm trying to read a comma-delimited file and save it's contents to a
> table. The file consists of seven comma-delimited records per line and
> then a hard return. I can set values using listLen and ListGetAT, but am
> running into a snag with the end-of-lines. Since there are no commas
> between the end of one line and the beginning of the next, CF
> concatenates the two records and throws everything off. Is there a way I
> can use replace or something else to change the hard returns to a comma?
> Can CF detect a hard return? Or is there some other easy way to do this?
>
> TIA,
>
> Doug Jordon
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
