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
@Simon1187
It will be easy if you only want the numbers or something else?
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)
@Simon1187
I assume your phone number will be longer than 6 digits.