Duane -- if you really don't have control over the input (ie you don't have
the option to use tabs instead of commas), you may have to write the import
code yourself. Read in one line, parse the line for strings inside double
quotes, change the commas in those strings to some type of place holder,
then use the CF "list" functions to process the list, eventually changing
your placeholders back to commas. I don't think there is any CF tag or
function that can do this for you.
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 12:32 PM
To: CF-Talk
Subject: List Question
Hi All,
I am writing an import routine that has to take into account quoted strings,
some of which may contain commas. How do you force the following string to
be 3 items?
1,1,"abc,def"
TIA,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
