what is the best tool?

[hi2019]

I need a tool or formula to remove for Address field - cleaning up data

• Remove symbols except - &
  • Omit extra space left for these symbols: ‘ . , #
  • Leave space in place of for these symbols: / +
• remove if 2+ spaces or extra space at beginning or end of data in cell

[Yoshiro_Fujimori]

@hi2019 ,

Though it may not sound very fancy, I would use Formula tool, as you can put in as many functions as you like.

Input / Output data

Input	Output
!"#$%&'()*+,-./	&
0123456789:;<=>?	123456789
@ABCDEFGHIJKLMNO	ABCDEFGHIJKLMNO
PQRSTUVWXYZ[\]^_	PQRSTUVWXYZ
`abcdefghijklmno	abcdefghijklmno
pqrstuvwxyz{|}~	pqrstuvwxyz

Expressions in Formula tool

Output = ReplaceChar([Input], "'.,#", "")

Output = ReplaceChar([Output], "/+", " ")

Output = ReplaceChar([Output], '!"$%()*-:;<=>?@[\]^_`{|}~', "")

Output = REGEX_Replace([Output], "^\s\s+", "")

Output = REGEX_Replace([Output], "\s\s+$", "")

[flying008]

Hi, Could you please upload sample data as input and output that your want.