Cleansing Data

Question

Hi everyone!

I hope you are well.

I would like to clean the data. In data I have phone numbers. In some of them I have + and in some of them I have : and string.

Could you please help me how I can clean it.

Please see the attachment.

I really appreciate your help in advance.

Thanks,

Simon

question.xlsx

Qiu · Answer

@Simon1187 
I assume your phone number will be longer than 6 digits.

New Workflow2A.yxmd

Emil_Kos · Answer

Hi @Simon1187,

I am not sure if I completely understand you but I think data cleansing tool can help you with your problem:

Regarding the line probably we can also make it work but you would need to provide us with more exceptions like that as I am understand 3 last digit should change for Lisa that is correct?

61410517975isDave(director),166isLisa(Opsmanager)

Data cleansing.yxmd

Simon1187 · Answer

Hi Toyo,

Thank you very much.

Also I want to remove Parentheses in that set and replace 02 to 61. Could you please help me with it.

Thanks,

Simon

Data - question.xlsx