Regex Help

Hello Friends,

I have attached a test sheet. It contains numbers and few alphabets but at the starting of the digits, there is a symbol that I am not able to remove. It does not shows in the Alteryx Result window but it is visible with Browse tool. Please tell me how can I keep everything in the same column except the symbol?

Test.xlsx

Dynamic Processing

Accepted answers

dwstada

the expression [^0-9a-z/-]?([0-9a-z/-]+) should help you. If you have symbols other than / and - in your data, add those in the expression (in both [bracket] lists)

remove a symbol.yxzp

All comments

Prometheus

@ArijitRoy I opened the file you attached and there is a weird character that looks like a question mark inside a box that comes before the digits in records 1-9. In Alteryx it presents as "_x000C_", so I just used the Replace function to get rid of it.

Replace Exp.PNG

Replace.yxzp

caltang

That ? symbol is actually an arrow symbol. You can see it in the formula of Excel here:

Because it is a symbol and not a character, it defaults to "_x000C_". Doing what @Prometheus did is the best method to remove it. It also changes your entire column into string type.

ArijitRoy

Hi Friends, I am getting this data from a text file. I gave you in excel that is why you are getting _x000C_ in front. I have attached a text file with same data. I need dynamic solution with RegEx formula.

New Text Document.txt

dwstada

the expression [^0-9a-z/-]?([0-9a-z/-]+) should help you. If you have symbols other than / and - in your data, add those in the expression (in both [bracket] lists)

remove a symbol.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703