kgittinger
asked on
How to replace 2 characters in a string?
How can I replace a "/" with and"@" and a "(" with a "_" that resides in a pipe delimited text string? I can do it individually, but not combined with the below
replace(split ({myfield},"!")[3], "/","@")
replace(split ({myfield},"!")[3], "(","_")
Thank you very much.
replace(split ({myfield},"!")[3], "/","@")
replace(split ({myfield},"!")[3], "(","_")
Thank you very much.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER