Here's a UDF at cflib that calculates a list length including nulls. I bet this will put you on the right track!
http://www.cflib.org/udf.cfm?ID=961 -Ferg -----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
