Couldn't you just do this
ReplaceNoCase(',,', ', ,', 'all') on your file variable? (So that ListLen would return the real number of commas.)
-----Original Message-----
From: Seth Bienek [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 03, 2005 1:39 PM
To: [email protected]
Subject: RE: count whatever value from .txt file without loop
Hey Ron,
The list and token features in CF skip empty values, so there's not a straightfoward way (that I know of) to count the commas
without some kind of looping.
Maybe a UDF like findit() will do the trick:
http://www.cflib.org/udf.cfm?ID=304
Take Care,
Seth
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Ron Mast
> Sent: Thursday, February 03, 2005 1:22 PM
> To: [email protected]
> Subject: RE: count whatever value from .txt file without loop
>
> How do I know it's empty if getToken skips it?
>
> Ron Mast
> Webmaster
> Truth Hardware
> Ph: 507-444-4748
> Fx: 507-444-5361
> www.truth.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
> Sent: Thursday, February 03, 2005 11:45 AM
> To: DFWCFUG
> Subject: RE: count whatever value from .txt file without loop
>
> yeah, you could do a replace for the empty commas
>
> On 2/3/2005 10:24:50 AM, [email protected] wrote:
> > Yep
> > that's exactly what we did...:)
> >
> > We have determined how many commas there are per line.
> >
> > BUT, now we have a different issue.
> >
> > Here's
> > what a line looks like:
> > 02/01/2005,12:46,02/01/2005,WBNC,2000001095245,TRUTH HARDWARE
> CO,A,Group
> > defined by system,060148,0000270960,2251.47,,T M COBB CO,RIVERSIDE
> >
> CA,121000248,4159400779,,,,959442,1812.10,0,,959442,,,,,0794,213667.30
> >
> > Can't use getToken because it skips over ",,,,". I'm thinking that
> > getToken goes to the next "," with a value only. How do get around
> > that?
> >
> > Ron Mast
> > Webmaster
> > Truth Hardware
> > Ph: 507-444-4748
> > Fx: 507-444-5361
> > www.truth.com
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> > Behalf Of [EMAIL PROTECTED]
> > Sent: Thursday, February 03, 2005 11:17 AM
> > To: DFWCFUG
> > Subject: Re: count whatever value from .txt file without loop
> >
> > use CFFILE to read contents into memory, then consider the
> content as
> a
> > comma delim'd list
> > and use ListLen() function
> >
> > On 2/3/2005 9:41:34 AM, [email protected] wrote:
> > > Hi All,
> > > I want to count how many commas there are in .txt file.
> How do I do
> it
> > > without using cfloop?
> > >
> > > Ron Mast
>
> ----------------------------------------------------------
> To post, send email to [email protected]
> To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> To subscribe:
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
>
> ----------------------------------------------------------
> To post, send email to [email protected]
> To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> To subscribe:
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
