Reg Expression in Alteryx

[rohit782192]

Hello Team,

How to write a regualr expression in Alteryx.

Is there any way to understand in a simple way.

[atcodedog05]

Hi @rohit782192 

Here are some resources which can help you get started. 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

Hope this helps : )

[MarqueeCrew]

Regular expressions are:  write once, read never 

cheers,

 mark

[georgewillv]

Hi @rohit782192 

In addition to the links @atcodedog05 posted, I've found that practicing regex expressions is a good way to learn how to use them. You can use a sandbox to practice your expression on the string you want to parse. 

Hope this helps (=

-George 

[atcodedog05]

Hi @rohit782192 

In addition to @georgewillv post here is the sandbox which I commonly use.

https://regexr.com/

Hope this helps =)

[clmc9601]

Hi @rohit782192,

There are some amazing resources above, but just thought I'd pile on my two favorite regex resources:

- regexone.com: fantastic for learning regex basics. Walks you through 70% of regex in an hour

- rubular.com: similar to a sandbox, lets you test your regex expressions in a Perl environment (close to the Alteryx one). It's a quick way to tell where your expression breaks.

[rohit782192]

I am not able to get as how we build expression.

[atcodedog05]

Hi @rohit782192 

Please make sure you cover these you should get a general idea.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-Regular-Expressions/ta-p/441412

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

Hope this helps : )

[Alteryx_AR]

@rohit782192 Hi Rohit,

I learned from here - 

Creating Regular Expressions - Alteryx Community

RegEx Tool | Alteryx Help

Hope this help you to get started .

Thanks