Alteryx Designer Desktop Discussions

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

Extracting level using RegEx

lagos-a1
6 - Meteoroid

Hi,

 

Would you be able to help extracting the level from the following sample strings: 

 

Input Output  1Output 2
L 7 1 MARTIN 71 MARTIN
NON - BUILDING  
L 9 50 MART950 MART
L 9 DLF CDLF C
L 5 1301 51301 
L 90 DVPA90DVPA

 

Kind Regards,

 

Andres Lagos

3 REPLIES 3
RobertOdera
13 - Pulsar

RobertOdera_0-1681749354022.png

 

ShankerV
17 - Castor

Hi @lagos-a1 

 

One way of doing this.

 

ShankerV_0-1681748198186.png

(\d+)\s(.+)

 

ShankerV_1-1681748217227.png

 

Many thanks

Shanker V

nagakavyasri
12 - Quasar

nagakavyasri_0-1681750690086.png

 

Labels