How about using ListGetAt() instead of GetToken()? Joe Kelly ----- Original Message ----- From: "Ron Mast" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 03, 2005 1:42 PM Subject: RE: count whatever value from .txt file without loop
> We can count the commas np. It's the getToken() function that we're > having issues with...:) > > 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 Seth Bienek > 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 > > > > > ---------------------------------------------------------- > 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
