We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex Capture Groups

rheepa
7 - Meteor

Hi All,

I have a question about RegEx Parse. I have the following string: "..a.stuff_my_month_to_delete" and the following Regular Expression: "(\.+(.*))_month". The Parse Output Method generates two output columns, with RegExOut2 being the desired one: "a.stuff_my". How do I suppress RegExOut1? Is a backreference needed and if so, how do I do it? 

Thanks!

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@rheepa 

The one pair of () will give one output, so we can remove one pair of them.

A good place for testing and learning RegEx. 😁

 

\.+(.*)_month

 

 

Qiu_0-1649894687575.png

 

 

rheepa
7 - Meteor

Thanks! I appreciate the help!

Qiu
21 - Polaris
21 - Polaris

@rheepa 
Glad to be helpful. 😁

Labels
Top Solution Authors