In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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