[Sharing] RegEx Cheat Sheet

[gawa]

Hi all,

I'd like to share my RegEx Cheat Sheet as attached, that I prepared for my self-study to make myself more understood about Regex function.

One day, I realized that I frequently google about similar topic on RegEx repeatedly, so in order to save my time, I determined to prepare it for my ready reference.

But I'm just wondering this material could be helpful to somebody else, so that brought me here.

Hoping this would help you somewhat! 

Please note that:

- I checked its content as much as possible, but if there might exist some mistake, please inform me.

- This is for Alteryx Designer Desktop, and not for other products.

- This cheat sheet doesn't cover comprehensive function is Alteryx Designer Desktop, but just covers the contents I feel it important and frequently used.

2023-11-08: Updated to Ver.2, added [[:punct]]

Thanks for suggestion @PhilipMannering 

[binuacs]

@gawa great stuff!!

[Raj]

Great!!

[caltang]

Here's some resources I'd like to share with you:

1. https://regex101.com/ -> Helps you identify your Regex and shows you where things go wrong. Easier to troubleshoot than guesswork!
2. ChatGPT -> Believe it or not, ChatGPT is great for Regex. Type in your structured sentence, and tell it with a prompt to REGEX it with Alteryx in mind. Also, give it clues as to how you want the expected result to be. I am learning way faster with ChatGPT!
3. https://regexone.com/ -> Basically like W3Schools, but for Regex.
4. https://www.rexegg.com/regex-quickstart.html -> I reference this from time to time to get a better grasp of REGEX. Don't try to force memorize, it doesn't work.

Some documentation from Alteryx as well:

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-RegEx/ta-p/376...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/RegEx-Examples-12-Handy-Use-Ca...

I've also attached a cheat sheet I keep printed out from MIT!

[PhilipMannering]

Looks good to me! I always forget whether ^ and $ refer to start/end of text or start/end of lines - this clarifies it.

Appreciate it's not exhaustive, but [[:punct:]] for punctuation might be a nice addition.

[gawa]

@PhilipMannering Thank you for your suggestion! 

Addition of [[:punct:]] would be a great idea, and I've updated attachment in my original post to ver.2.

[amster27]

This is so helpful - thanks so much!

[sai_kumar_m]

REGEX_Replace(TRIM(REGEX_Replace([InputField], "[^0-9]+", ",")), "^,|,$", "")