Data cleaning

[rajputakansha]

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

[Thableaus · Accepted solution]

Hi @rajputakansha 

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

Cheers,

[rajputakansha]

@Thableaus ,

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