0 votes
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
asked by

1 Answer

0 votes

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

answered by
Ah exact! Thank you very much for such fast answer!
Have a nice day
836 questions
866 answers
806 comments
955 users