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.
RaghuThis message has been edited. Last edited by: Kerry,
Excel, PDF, HTML
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
WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000.
OS: Windows & AIX
|Powered by Social Strata|