Cleansing Data

[Simon1187]

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

[Qiu]

@Simon1187 
It will be easy if you only want the numbers or something else?

[Simon1187]

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

[Emil_Kos]

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)

[Qiu]

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