Ian, upon your building your parsed list, can't you just specify an obscure
delimiter like a pipe | character? I've always done it this way and been
quite effective on comma formatted numbers like you have.
I don't build the parsed list; I am reading it from a CSV file. In this
particular
I am reading it from a CSV file. In this particular case Excel
created the file.
Can't you set up a DSN with the ODBC text driver?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
Ian,
you can try my CSV2Query custom tag:
http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=cf_csv2query
Try our live example, copy paste your CSV and see the result...
It can handle great deals of CSV problems like text qualifier inside
qualifier, or delimiter inside
Michael E. Carluen wrote:
Ian, upon your building your parsed list, can't you just specify an obscure
delimeter like a pipe | character? I've always done it this way and been
quite effective on comma formatted numbers like you have.
if I think it's gonna be an issue, I'll *OFTEN* use chr(1)
What's the best way to handle this issue in CF?
List = 'this,that,the other,1,234,Foobar,2,098'
Do I need to manipulate the delimiters?
Never mind, Yes I do. I need to remove the comma from the data elements that
have it. They need to be numbers, not strings with a comma, in CF so that I
I think there is some kind of CSV parser UDF on cflib.
I don't even want to think about how to do this, cuz it'd be freakin' hard.
For example, what if you've got a quoted value in your list with quotes
in it?
cfset list = '1,2,2,045,This would suck, he said.'
Rick
I was working on a import function last week and needed this, didn't find
anything at CFLib, but did find this one searching the old posts on this list.
Does a great job at handling such issues.
function ParseCSV(lstCSV) {
/*
Object: ParseCSV
Purpose:Include to parse a CSV
, August 22, 2006 3:56 PM
To: CF-Talk
Subject: RE: Handle lists with delimiters in the data.
What's the best way to handle this issue in CF?
List = 'this,that,the other,1,234,Foobar,2,098'
Do I need to manipulate the delimiters?
Never mind, Yes I do. I need to remove the comma from
8 matches
Mail list logo