RE: [sqr-users] Putting single quotes in a string

[Don Mellen <donm@ontko.com>]

Ewan is right, replace does work.

let $a = '''' || replace($a , ',' , ''',''') || ''''

On Thu, 11 Mar 2004, Ewan Kho wrote:

> 
> I have not actually tried it, but maybe you can use the function replace to 
> change all the commas into ','
> 
> 
> >From: "Turner, Ivan" <Ivan.Turner@qwest.com>
> >Reply-To: "This list is for discussion about the SQR database 
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: <sqr-users@sqrug.org>
> >Subject: [sqr-users] Putting single quotes in a string
> >Date: Wed, 10 Mar 2004 23:13:40 -0600
> >
> >If I have a string:
> >$a = 'abc,def,ghi' as user input
> >
> >How can I make it look like 'abc','def','ghi'?
> >
> >I tried "translate" and can't get it to work.  Does anyone know of a 
> >function available to do this?  Maybe I have to resort to parsing the 
> >string and rebuilding it via hard coded logic.
> >
> >Any suggestions?
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org
> >http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


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