RE: [sqr-users] Add comments to an input string.

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

And because you're changing a single character to another single character,
you could also use translate.

-----Original Message-----
From: Jon Alsager [mailto:Jalsager@ISIF.STATE.ID.US]
Sent: Wednesday, May 12, 2004 1:51 PM
To: This list is for discussion about the SQR database reportinglanguage
fr omHyperion Solutions.
Subject: RE: [sqr-users] Add comments to an input string.


Although I don't know which version this became available, you could try
the SQR command "replace":

$text = '000 001 002 003 004 005'
let $new_text = replace($text,' ',',')

($new_text shows as 000,001,002,003,004,005)

At least this seems to work for me.

Jon Alsager
State Insurance Fund
jalsager@isif.state.id.us
208-332-2573

-----Original Message-----
From: sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org
[mailto:sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org] On Behalf
Of DICKMAN, ERIC C.
Sent: Wednesday, May 12, 2004 2:42 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Add comments to an input string.

Hello everyone,

I have a input parameter that I am passing into my SQR file. For
Example,
'ask INV_NUM'. INV_NUM is a String that looks something like '000 001
002
003 004 005'. Is it possible to add commas to the blank spaces in SQR,
so
the String looks like '000,001,002,003,004,005'.

Thanks,

Eric

NOTE: The Texas Department of Protective and Regulatory Services (TDPRS)
has
changed its name to the Department of Family and Protective
Services(DFPS)
resulting in the following e-mail address format change for all
employees:
firstname.lastname@dfps.state.tx.us 

_______________________________________________
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