RE: [sqr-users] quickest way to count how many commas are in a string

["Simpson, Don I \(UK\)" <Don.I.Simpson@baesystems.com>]

I haven't tried this myself, but it should/might work.

Copy your string into a second temporary variable. Do a REPLACE on this
string to change all ',' to '' (null). Get the length of your original
and the "replaced" temporary string. The difference in length is the
number of commas.

Regards,

Don Simpson
BAE Systems 

-----Original Message-----
From: sqr-users-bounces+don.i.simpson=baesystems.com@sqrug.org
[mailto:sqr-users-bounces+don.i.simpson=baesystems.com@sqrug.org] On
Behalf Of Overcashier, Patricia
Sent: 13 October 2006 13:06
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] quickest way to count how many commas are in a
string

               *** WARNING ***

This mail has originated outside your organization, either from an
external partner or the Global Internet. 
     Keep this in mind if you answer this message.

I have a string called $selectlist

I need to know how many commas are in it.
Once I know I can unstring it by commas into the right number of
variables and then use those variables What is the simplest way to get a
count of the commas?
Thanks!

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



********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************

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