Replace
Use the Replace expression type to search and replace a string with a specific replacement value. (The replacement value can be characters within the string.)
Use parameters that follow this form: replace(Dimension, "x","0")
. For example, if an account number is "123x456x" and you want to replace each "x" with a "0", specify: replace(ACCOUNT , "x","0")
as the expression. In this example, the result is: 12304560.