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*$
Solved! Go to Solution.
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.
That worked! Thank you so much!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |