Alteryx Designer Desktop Discussions

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

Help Creating Expression with RegEx

cmStuhl
7 - Meteor

Hello, 

 

I am having difficulties creating an expression to parse data with the RegEx tool. I am trying to separate these into 5 groups as highlighted.

 

A typical line of the data I need to parse looks like the below: 

 

-pw-pw-pw-    1 sdummy    rtaftp         88 Mar 20 00:00 1000024_SAMPLE_SAMPLE_20230319.csv 

 

I am currently using the following expression but have not gotten any hits. Anyone have any advice? 

 

^.*?(\l2}-\l{2}-\l{2})\s+(\d+)\s+(\d{2}-\d{2}-\d{2})\s+\s+(\d+)\s+(.+\.\w+)\s*$

 

 

cmStuhl_0-1683066294055.png

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora

Hi @cmStuhl ,

 

This expression worked on my Designer. Please check.

(-\l{2}-\l{2}-\l{2}-)\s+(\d+\s\l+)\s+(\l+)\s+(\d+\s\w+\s\d{2}\s\d{2}:\d{2})\s(\w+\.\w+)

 

This site is highly recommended as you can test your RegEx real time.

https://regex101.com/

 

cmStuhl
7 - Meteor

That worked! Thank you so much!

Labels