Oh okay. I thought maybe you did not have access to the newer version of
ListToArray (that preserves empty elements). I am sure either way works, but
ListToArray is slightly more convenient because it is built in.
-Leigh
~~~
;W Unplugged
http://www.austin-williams.com/unplugged
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, October 08, 2010 1:12 PM
To: cf-talk
Subject: RE: ListFunction Question
Are yo
Are you running pre-CF8?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-t
> http://www.cflib.org/udf/ListFix
Wahoo!
That worked like a charm. Thanks.
Now I feel ready for the weekend!
Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100
Hauppauge NY 11788
P : 631.231.6600 Ext. 119
F : 631.434.7022
http://www.austin-
http://www.cflib.org/udf/ListFix
Thanks,
Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com
Robert Harrison wrote:
>> CF ignores things like ,,
>>
>
> Yes, and this is killing me. I'm trying to parse a comma delimited file to
> import to a data base, but if
> How do I deal with that?
Use arrays. As someone else mentioned, the ListToArray() function has a third
parameter that will preserve empty elements.
ie ListToArrary(list, delim, preserveEmptyElements)
~|
Order the
> CF ignores things like ,,
Yes, and this is killing me. I'm trying to parse a comma delimited file to
import to a data base, but if a column is blank all the columns following
the ,, blank column get put in the wrong bucket.
How do I deal with that?
Robert B. Harrison
Director of Interacti
: cf-talk
Subject: RE: ListFunction Question
Tried that - listlen() is showing me the total number of elements in the
entire list, including all rows. I need to tell how many columns are in the
list or just tell if a column exists.
Robert B. Harrison
Director of Interactive Services
Austin
ms.com
>
> Great advertising can't be either/or. It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
>
> -Original Message-
> From: John M Bliss [mailto:bliss.j...@gmail.com]
>
ow.
Can't see I've ever seen a variable row length csv though.
Also, didn't test this so I could be wrong.
Steve
-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com]
Sent: Friday, October 08, 2010 12:02 PM
To: cf-talk
Subject: ListFunction Questi
ss.j...@gmail.com]
Sent: Friday, October 08, 2010 12:04 PM
To: cf-talk
Subject: Re: ListFunction Question
listlen()
__ Information from ESET Smart Security, version of virus signature
database 5515 (20101008) __
The message was checked by ESET Smart Security.
ht
listlen()
On Fri, Oct 8, 2010 at 11:02 AM, Robert Harrison wrote:
>
> I have a CSV File of unknown length with an unknown number of columns. I
> loop through the file and use
> #listgetAt('#index#',1,',')# to get the elements of the file, but I don't
> know how many elements (columns) there are
I have a CSV File of unknown length with an unknown number of columns. I
loop through the file and use
#listgetAt('#index#',1,',')# to get the elements of the file, but I don't
know how many elements (columns) there are.
I'm trying to say only get an element if it exists, something like:
13 matches
Mail list logo