Regex parse log files

[Loperal]

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

[afv2688 · Accepted solution]

Hello @Loperal,

How about using the following command on a reges tool:

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

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

Regards

[Loperal]

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!!