Hello!
I'm cleaning my data but I need to remove a value from the last space, when it starts the ID:
Example
Johnny Anderson JA303030
Melissa Amy May MA303030
Nicole Pedward NP303030
Desired output:
Johnny Anderson
Melissa Amy May
Nicole Pedward
Hope you can help me!
Résolu ! Accéder à la solution.
Hi @aramirez069 ,
Here is 2 suggestions for you.
First one is considering that your last word is always the same length and the 2nd is removing the last word without any size concern.
Translating the regular expression
(.*)\s\w+
. - any character
* - 0 or more times
\s - space
\w word character
+ one or more time
A little about REGEX: https://community.alteryx.com/t5/Alteryx-Designer/Tool-Mastery-RegEx/ta-p/37689
Best,
Fernando Vizcaino
Thanks so much! This has solved my problem