one option is to use the replace(myContent, ",,", ",|', "all") function to replace repeated commas (empty list item) with a placeholder such as pipe "|" before you use ListLen()
On 2/3/2005 12:22:23 PM, [email protected] wrote: > 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 > ---------------------------------------------------------- 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
