Regex to remove special characters

Hi community Happy new year,

I'm not to good with RegEx but I know it is needed in my use case. I have these company names but they contain special characters and i'm not sure how to remove them. I've attached a mini dummy sample of the data below.

Any assistance with this would be majorly appreciated

Name

Test Company 1 â€“Limited

Test Company 2â€™s Ltd

Oâ€™Test Hotel Limited

Workflow

Accepted answers

binu_acs

@DataIsFun One way of doing this

All comments

FinnCharlton

Try REGEX_Replace([String],"[^a-z,A-Z,0-9,\s]","")

This gets rid of all characters that are not special letters, spaces or numbers.

binu_acs

@DataIsFun One way of doing this

Deano478

@binu_acs I saw your solution and I'm just wondering how does your Regex work? 😀

binu_acs

@Deano478the regex formula

REGEX_Replace([Name], '[^ -~]', '')

Remove any characters from the incoming field that are outside of the range of ASCII values from "space" to "~".

^ - represent the not operator

<space> - ~ characters with in the range space and ~

Below is the ASCII table where you can see the range 32(space) - 126(~), so any characters that fall other than this range will get replaced with ''

Deano478

@binu_acs that's actually very interesting to read I will definitely read more into regex to get more comfortable with it myself it seems very powerful when used the right way.

malcorr

hello, i like this solution but i want to apply it in a text field that contains text in japanese, chinese and korean. How can i address that as well?

binu_acs

@malcorr If you want to include the Japanese, Chinese, and Korean then find their corresponding ASCII characters and include those also in the regex expression, if you can provide some samples I can help you with this.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703