Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] rplacing characters in the strig
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] rplacing characters in the strig
 Login/Join
 
Gold member
posted
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
 
Posts: 56 | Registered: February 04, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 71 | Registered: November 20, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] rplacing characters in the strig

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.