RE: [sqr-users] Easy way to find count of delimiters in unstring?

[kevin.reschenberg@sparkpath.com]

let #CommaCount = length($MyString) - length(replace($MyString, ',', ''))
 
Kevin Reschenberg
SparkPath Technologies, Inc.
 
sparkpath.com | sqr-info.com
 


 -------- Original Message --------
Subject: [sqr-users] Easy way to find count of delimiters in unstring?
From: "Ackerson, Glenn" <Glenn.Ackerson@unco.edu>
Date: Fri, July 07, 2006 11:53 am
To: <sqr-users@sqrug.org>

Hi all,
 Any suggestions on finding a count of the number of comma delimiters
on a variable length, comma-separated (.csv) file I'm processing? I'm
able to successfully parse values in each record no problem, using the
unstring command. But, the situation I'm trying to determine options on
is to find out how many comma delimiters exist on each record.
Unfortunately, the vendor who created this file didn't consistently use
commas in every case where a value doesn't exist. Any ideas anyone? If
so, since I subscribe in digest mode, would you kindly respond to me
directly? Thanks much.

Cheers,
Glenn

**************************************************
Glenn Ackerson                               Phone: (970) 351-1460
Information Technology Professional III Fax:   (970) 351-1650
Internet Address: Glenn.Ackerson@Unco.edu
University of Northern Colorado
Information Technology  
Carter Hall                  Greeley, CO  80639

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users