Data cleaning

Hi all,

I have a column that has all numerical values. But there are some special characters too that I am trying to strip out.

Input:

",

",

23

34

45",

",

56",

",

78

I need it to be:

23

34

45

56

78

Can anyone help me in achieving this in RegEx. Or any other way possible?

Thanks

Workflow

Datasets

Output

Accepted answers

Hi @rajputakansha

If you just want to strip out punctuation use the Data Cleansing tool under the Preparation Tab.

Cheers,

All comments

Hi @rajputakansha

If you just want to strip out punctuation use the Data Cleansing tool under the Preparation Tab.

Cheers,

Thanks for your reply.

I figured out 2 more ways to do this.

1. REGEX_Replace([Field], "[\D]", "")

2. Replace([Field],'",',"")

Yours one is obviously the easiest one. 🙂

Thanks

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703