Alteryx Designer Desktop Discussions

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

Quick Regex Parse Question

hellyars
13 - Pulsar

Hey,

 

I am trying to parse the following.   I often use Regex 101 to bumble my way through regex.

 

4010-Tacos F0B000 [YB#3] - Eat More Tacos.pdf

 

I tried the following expression.  It works on Regex101, but I can't get it to work with our favorite piece of software.

 

(\d{4}).*?\s(.{6})\s.*?(\d{1,3}).*?([A-Z].*?)\.

 

I can brute force it, but I there has to be an easier explanation / solution.

 

Thanks.

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @hellyars 

 

Can you provide a sample output on what are the parts you trying to capture.

hellyars
13 - Pulsar

In the example it would be, well I forgot the example.

 

Start

4010-Tacos F0B000 [YB#3] - Eat More Tacos.pdf

 

From this I want...

 

4010, F0B000, 3, Eat More Tacos

 

 

 

 

hellyars
13 - Pulsar

I got this to finally work.

 

(\d{4}).*?\s(.{6})\s.*?\#(\d{1,3}).*?\s(\u.*?)\.
Labels