topic DPL Help Pls in DQL

DPL Help Pls

DwayneWhite — Wed, 25 Sep 2024 21:06:28 GMT

Using the below Data, I was attempting to extract the folder and the file from this example log entry. Here is what I started with and got no further. Any guidance would be greatly appreciated.

TIMESTAMP("yyyy-MM-dd HH:mm:ss,SSS"):current_time SPACE
DIGIT:transfer_time SPACE
IPV4:remote_host SPACE
DIGIT:file_size SPACE
[^(.*/)\[^/\]]*:folder

Data
2024-09-25 13:04:02,536 0 10.22.10.10 36 /folder/partners/gump/Texax02/incoming/PFPT/pcmm/Errors/SMS_production-cg2/mmm01_utl_issues_conrepor.csv b s i r dispcgmftp ssh 0 *

Re: DPL Help Pls

Fin_Ubels — Wed, 25 Sep 2024 22:57:55 GMT

Hey Dwayne,

I wasn't able to figure it out with DPL, but if in the situation it is possible to also use DQL after the fact then you could do something like the following:

Hope this helps

Re: DPL Help Pls

DwayneWhite — Thu, 26 Sep 2024 13:14:04 GMT

Thank you!!!!