Hi. I've got to create a little cffile for importing a csv file that 
uses "" as the text qualifier. I'm presuming the quotes will just 
tell the database on a manual import to ignore any commas between the 
quotes. But, how will this work with cffile if I loop through each 
row? There may be some commas in the fields as some are descriptions, 
Company names (Company, Inc.), etc.

I'll use chr(10) as the outside loop delimiter. On the inside, would 
you just use something like:

delimiter="#chr(34)#,#chr(34)#"

then replace the first and last quote from each row? Or does someone 
have a cleaner way?

Thanks.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.

Reply via email to