Parsing out Special Characters

We have a large report that has several different special characters that is causing our data files to fail when importing into our system.

Is there a way within Alteryx to find and remove these special characters that we are not aware of. There are MANY different types that we are finding. We have tried using the data cleansing tool; however, this is not catching everything. Example of one character we are seeing is :Â.

Data Investigation

Accepted answers

All comments

Elias_Nordlinder

Hello @baileyblough ,

How about doing this with a RegEx_replace formula in a formula tool.

You can try this formula for what you are looking for:

Regex_replace([Field1],"([^a-z])","")

-> It looks for everything that is not a normal character and removes it.

If you want to keep numbers, but only remove special characters you can change the expression to

Regex_replace(Field1,"([^a-z|^\d])","")

I have tried it with a lot of different samples this far and do not find anything that does not work.

//Best Regards
Elias

REGEX Special Char.yxmd

fmvizcaino

Hi @baileyblough ,

Another option there is to use DecomposeUnicodeForMatch(String) function, but in this case, it will transform all to lower cases, which you can treat with Title case funcion for example.

Best,

Fernando Vizcaino

atcodedog05

Nice @fmvizcaino , DecomposeUnicodeForMatch([Field1]) works well for this scenario.

Thanks for sharing @fmvizcaino. Got to learn something new 🙂.

baileyblough

Is there a way to use this expression but also retain a dash character?

Maskell_Rascal

@fmvizcaino & @atcodedog05 - I love this exchange! 🙂

I am constantly stealing with pride all these wonderful little snippets of workflows from this community. I've learned more through the weekly challenges and attempting to provide solutions to others' posts than I would've in my day to day job.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703