Hello, i have multiple columns with strings prefixed by numerics and zpecial characters
17;#Tim, kan
347;#Low, Jim
24;# Sou,Xi
I want the out put as
Tim, kan
Low, Jim
Sou,Xi
¡Resuelto! Ir a solución.
Hey @Avatar!
Will your field always have a hashtag before the part you want to keep? If so, the following code will work:
REGEX_Replace([Field1], "(.*\#\s?)(\u.*)", "$2")
Otherwise, a more diverse approach may be with this:
REGEX_Replace([Field1], "(\d+\W+\s?)(\u.*)", "$2")
Hi Quasar,
Works perfectly .. Thank you so much!!!
I am glad to see that @Kenda has helped you to solve your challenge. I do want to add another option to the post in case others may come across this in the future. My friend @LordNeilLord often asks me about alternatives and their performance. While I like the formula tool for parsing because of a variety of preferences, this case made me want to use the RegEx tool directly.
In looking at your pattern, I saw the following:
What I really saw was a group of 1 or more word characters followed by a comma including anything else.
(\w+,.*)
When I put this into the above pictured tool, the configuration I thought was simple and my expression was less complex than the formula. This solution is 50% more efficient (timed with 3,000,000 rows of data) than the formula technique in terms of time spent processing.
I've included the workflow here for you. To test the comparison of results, disable one container and run. Then repeat. Then switch enable/disable and repeat tests.
Cheers,
Mark