comma Delimited file

Forum|Forum|18 years ago
August 7, 2007
4 replies
720 views

Hello,

I have a need to insert a csv file into a table. I am having a problem with the insert query, three of the 132 fields commonly have commas in the text within the field and making the query barf. Please help.

Matt

This topic has been closed for replies.

F

fyrehedAuthor

Inspiring

Phil,

When you say "ODBC", are you referring to setting up a datasource in the ColdFusion administrator? The administrators will not make a datasource to this file. If there is another way, please let me know.

Thanks for your help.

F

fyrehedAuthor

Inspiring

phil,

So, the comma delimited file which is produced from Multiple Listing Service, should be something other than comma delimited. Problem is; This software lets you have any format you want, as long as its comma delimited :). Can anyone point me to a direction of converting the comma delimited to another delimiter with Coldfusion?

Matt

P

philh

Inspiring

Try using "," (that is, quote-comma-quote) as the delimiter. That of course wouldn't help if you have that string in a value ;^).

Have you tried setting up an ODBC connection to the file?

I'll get on MLS this evening and see what I can do with it.

T

tmschmitt

Participating Frequently

A CSV that contains text really should use a qualifier like double-quotes, as you can't always control what characters will be in the data, then you won't have that issue.
You would have to modify your CF insert code or use one of the many UDFs/CFCs that already exist and can handle the qulaifier.

P

philh

Inspiring

You need another delimiter. There is no way to differentiate the commas in values from the comma delimiters.

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