In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Regular expression for Regex tool

ShankerV
17 - Castor

Hi @AkimasaKajitani 

 

For challenge 308, I saw your solution and noticed you have used advanced Regular expression in the RegEx tool.

 

Could you please share the best way to get expertise in writing the Regular expression.

Any tips and tricks if you have/follow.

 

Thanks in advance

 

2 REPLIES 2
joelmiller66
9 - Comet

@ShankerV  when you use the regex tool, there is a 'cheat sheet' you can access by clicking the + sign by the expression section.

 

This is a good place to get started. But you can also use sites like https://regex101.com/ or even on Alteryx there are resources https://help.alteryx.com/20221/designer/regex-tool

 

joelmiller66_0-1666722731286.png

joelmiller66_1-1666722750046.png

 

 

AkimasaKajitani
17 - Castor
17 - Castor

Hi @ShankerV 

 

Basically, Alteryx adopts Perl's regular expression syntax. So, you can use the general regular expression tool.

 

And also you can use these resources.

 

Introduction to Regular Expressions

https://community.alteryx.com/t5/Technical-Resources/Introduction-to-Regular-Expressions/ta-p/56710

How to Get Started with Regular Expressions

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Get-Started-with-Regular-Exp...

 

Labels
Top Solution Authors