Replace

[rtorres7157]

I have a text column with some classification variables that I am wanting to remove the 1's and leave the test of the text

Urban1

Exurban1suburban1

Rural1

Any help is appreciated

[fmvizcaino · Accepted solution]

Hi @rtorres7157 ,

You can use the replace function to remove all 1's.

Replace([Field1], '1', '')

Example attached.

Best,

Fernando Vizcaino

[grazitti_sapna · Accepted solution]

Hi @rtorres7157 , if you just want to remove any number you can do the same with the help of regex tool, formula tool as well as data cleansing tool. Please refer to the screenshot. There are n  number of methods but I have specified 3 of them.

Thanks.