Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Regex parse log files

Meteoroid

Guys,

 

Regex tool is great but it seems today we are not geeting along together.... what a valentin!   

 

I have following string and want to capture everything that comes after the words "records were read from"  the structure changes from time to time but those words are always there.

 

what would be the code using the Regex tool?  would somebody please give me a hand

 

00:00:1.752 - ToolId 284: B:\GLOBAL\0050\LUDWIGSHAFEN\EV\EV-C\EVCOCKPIT\EVOLVE\Price List\v2\PMM Light File Coolants & Brake Fluids.xlsm|1999 records were read from "B:\GLOBAL\0050-LUDWIGSHAFEN\EV\EV-C\EVCOCKPIT\EVOLVE\Price List\v2

 

Thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @Loperal,

 

How about using the following command on a reges tool:

 

(.*)(records were read from)(.*)

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
Meteoroid

Hi,   

 

Many thanks that worked out, also found out something like this would work .+read from (.+)   

 

So my issue is solved but I still have to master this tool

 

Again thanks!!

Labels