Start Free Trial

Alteryx Designer Desktop Discussions

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

Teg ex expression

JBATAIDE
7 - Meteor

Hi,

 

What would be the expression for extracting parts of the string text between the first and the last character, in this case '_'?

 

I have entered the following expression but it is capturing the text between the first two

 

\_(.*?)\_

 

Data:

//text_A_B_C_text

 

It is coming back with A but I would need it to come back with 'A_B_C'

 

Thank you very much,

 

Joao

1 REPLY 1
OllieClarke
16 - Nebula
16 - Nebula

Almost there @JBATAIDE try this instead:
_(.*)_

 

Ollie

Labels
Top Solution Authors