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