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.