Alteryx Designer Desktop Discussions

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

Regex tool

BRRLL99
11 - Bolide

Hi 

 

I have following data set

 

a/b/c/d/E_F_G_H_20230201_20220646_EXEMPTION_20225786.CSV

 

I need only E_F_G_H

2 REPLIES 2
Luke_C
17 - Castor

Hi @BRRLL99 

 

I'm sure there's many ways to do this, but here's one option:

 

.*(\u_\u_\u_\u).*

 

Luke_C_0-1663336131807.png

 

 

DataNath
17 - Castor

Used the following to get this. However, with only a single line of data to check against and what looks to be dummied names (A-E) I've got no idea if this will satisfy your actual data:

 

.+\/(\D+)_

 

DataNath_0-1663336270186.png

Labels