How to replace char ~

[prakash-shetty]

I have char ~ in multiple columns. I am trying to use replace in formula tool to remove it, but not working. Can someone help me on this.

[abacon · Accepted solution]

@prakash-shetty Use a multi-field tool, select the columns you want the character removed from, and use the formula below.

Replace([_CurrentField_], "~", "")

Bacon