Split numbers from Text

Meanwhile, can you please tell me if this tool offers flexibility to keep the original column as it is and populate the # in another column (the way I mentioned in the desired output demo)?

Regards,

Jonathan-Sherman

Hi @Learn2Excel,

This is possible in one RegEx tool in parse mode with the following expression:

((?:[A-Z]+)|(?:\d+))((?:[A-Z]+)|(?:\d+))?((?:[A-Z]+)|(?:\d+))?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200507 - RegexParse.yxmd

Learn2Excel

Dear Jonathan,

This is exactly what I was expecting to achieve through one tool, thanks for sharing.

I was trying to look at some articles on RegEx in this community, however, RegEx looks little daunting (:)), but I am sure this tool has enormous possibilities if one can make it working.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/RegEx-Perl-Syntax-Guide/ta-p/1288

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/RegEx-Examples-12-Handy-Use-Cases/ta-p/40680

While I will continue to explore these posts, could you please explain me the specifiers you used to construct this expression? [((?:[A-Z]+)|(?:\d+))((?:[A-Z]+)|(?:\d+))?((?:[A-Z]+)|(?:\d+))?].

If you could break it and explain, that would be really helpful for me to explore further.

Also any good reading material on this, which explains RegEx from beginning with examples and it's syntaxes, that would be very helpful too.

Thanks for your tremendous help!

Regards,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703