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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

Use translate to replace all the commas with null, then subtract the length
of the new string from the length of the original string.

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu] 
Sent: Friday, July 07, 2006 12:01 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Easy way to find count of delimiters in unstring?


Create a function to count 'em using pos and instr.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Ackerson, Glenn
Sent: Friday, July 07, 2006 1:53 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Easy way to find count of delimiters in unstring?

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

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