REPLACE Function

nate100

Member
Hello,
Say if I have the following string:

"Hello it's there & here as well".

I like to replace where I see " ' " and " & " with say " : ".

I know how to use the replace function but how would I use it to replace both " ' " and " & " with say " : "

Thanks
 

tamhas

ProgressTalk.com Sponsor
You are going to have to use nested replace statements or two separate replace statements.
 
If it is static then I think you can use the substitute statement also like,
disp substitute("Hello it&1s there &2 here as well",":",":") format "x(50)".
 
Top