Focal Point
[CLOSED] rplacing characters in the strig

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/854101525

September 10, 2010, 05:04 AM
raghuram
[CLOSED] rplacing characters in the strig
Hi ,

I have a string like 'RAGHU %26% RAM' i need to change 'RAGHU & RAM' how to do like this.
I tried with replace function.
But i am facing problem with syntax.Can any body how to replace the above string.


Thanks,
Raghu

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
September 10, 2010, 01:14 PM
krishkasi
Raghu,
You could try below. It worked while I was trying to do from MRE.

 
-SET &NAMEVAL = 'RAGHU %26% RAM';
-SET &NAMEREP = STRREP(&NAMEVAL.LENGTH,&NAMEVAL,4,'%26%', 1,'&|',&NAMEVAL.LENGTH, 'A&NAMEVAL.LENGTH');
-TYPE &NAMEREP



Regards,
Kasi Krishnan
WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000.
OS: Windows & AIX