cleaning cell from the numbers
![AnastasiiaSolom](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar7.png)
AnastasiiaSolom
Registered Posts: 13 ✭✭✭✭
Hello!
I have a question according the cleaning data. I have the colomnes with names and surenames and some times i have some numbers with the text information, as:
NOM PRENOM
Soloma Anastasiia2
Ri5grit Stephanie
Is any code existe to clean all the numbers from these colomnes?
Thank you in advance!
Best regards,
Anastasiia
I have a question according the cleaning data. I have the colomnes with names and surenames and some times i have some numbers with the text information, as:
NOM PRENOM
Soloma Anastasiia2
Ri5grit Stephanie
Is any code existe to clean all the numbers from these colomnes?
Thank you in advance!
Best regards,
Anastasiia
Tagged:
Answers
-
Hi Anastasiia,
Yes, you can do that easily with DSS. Create a Prepare recipe and add a new "Find & Replace" step.
The simple/easy way is to replace 0 with nothing, 1 with nothing, ... 9 with nothing.
A better way to do it, is to replace all occurrences of the regular expression [0-9] which matches any digit.
If you want to remove the numbers in multiple columns, configure the step accordingly as in the above screenshots.
Hope this helps,
Arnaud
VP Engineering, Dataiku
-
Ah exact! Thank you very much for such fast answer!
Have a nice day