cleaning cell from the numbers

AnastasiiaSolom

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

Arnaud_PICHERY

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

AnastasiiaSolom

Ah exact! Thank you very much for such fast answer!
Have a nice day