Removing the Comma delimiter with something else in a File download

Question

I have a file whcih gets downloaded and then read and inserted into the database. The problem is when I read the belwo records below which should be 3 indexes, it breaks the index with the comma delimted file into 5 indexes.

"","","Wonderful Expanded Cape, With 4/5 Bedrooms 2 Full Bths. Eik, Lr,Great Place, New"

How can I replace the comma delimited in the file when downloaded and the use that delimiter in my ListToArray .

</cfloop>

Anonymous · Accepted Answer

To retrieve the data's embedded in quotes, u can use the function in the following url by passing ur string conataining commas as argument.http://www.cflib.org/udf/CSVtoArray

Dan_Bracuk · Answer

If the delimiter commas are surrounded by double quotes, you have several options.

1. After uploading the file, read it with cfhttp instead of cffile. The text qualifier attribute will be helpful.

2. Set some variable to "," and use it as your delimiter.

3. Replace the "," with a single character, like a pipe.

Note that for options 2 and 3, you'll have to do something about the leading and trailing quotes. For all three options, you'll need a plan for dealing with empty fields.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded