topic SPL in Splunk Search

SPL

Muthu_Vinith — Wed, 21 Feb 2024 01:08:08 GMT

Hey Experts, I'm new to splunk and I'm trying to extract APP WEB and MNOPQ from a field called result. Can someone please guide me on how to achieve this? Any help or example queries would be greatly appreciated. Thank You!

Fi a:\abc\def\MNOPQ.txt content is expected to include "A H Dis Query,0,0" Fi a:\abc\def\APP.txt content is expected to include "A H Dis Query,0,0" Fi a:\abc\def\WEB.txt content is expected to include "A H Dis Query,0,0"

Re: SPL

gcusello — Mon, 12 Feb 2024 13:24:11 GMT

Hi @Muthu_Vinith ,

you should use a regex like the following:

| rex field=result "\w:\\\w+\\\w+\\(?<myfield>[^\.]+)"

that you can test at https://regex101.com/r/BYH1rP/1

Ciao.

Giuseppe

Re: SPL

ITWhisperer — Mon, 12 Feb 2024 13:30:05 GMT

| rex field=result "\w:\\\\\w+\\\\\w+\\\\(?<myfield>[^\.]+)"

Re: SPL

yuanliu — Mon, 12 Feb 2024 22:02:30 GMT

@Muthu_Vinith Please use descriptive title. This helps future users finding the answer.

Re: SPL

Muthu_Vinith — Wed, 14 Feb 2024 01:09:07 GMT

Thanks!! @gcusello @ITWhisperer

Re: SPL

gcusello — Wed, 14 Feb 2024 07:19:15 GMT

Hi @Muthu_Vinith ,

good for you, see next time!

let us know if we can help you more, or, please, accept one answer for the other people of Community.

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated by all the contributors 😉

Re: SPL

Muthu_Vinith — Sun, 18 Feb 2024 09:05:39 GMT

Hi @gcusello @ITWhisperer

| rex field=result "\w:\\\\\w+\\\\\w+\\\\(?<myfield>[^\.]+)"

The above query extracts, but if i want to extract APP and WEB which is in same line how to extract ?

Fi a:\abc\def\MNOPQ.txt content is expected to include "A H Dis Query,0,0"
Fi a:\abc\def\APP.txt content is expected to include "A H Dis Query,0,0" Fi a:\abc\def\WEB.txt content is expected to include "A H Dis Query,0,0"
Fi a:\abc\def\SQL.txt content is expected to include "A H Dis Query,0,0"

Re: SPL

ITWhisperer — Sun, 18 Feb 2024 09:20:22 GMT

Use max_match

| rex max_match=0 field=result "\w:\\\\\w+\\\\\w+\\\\(?<myfield>[^\.]+)"

Note that this will give you a multivalue field

Re: SPL

Muthu_Vinith — Sun, 18 Feb 2024 09:33:17 GMT

Thanks @ITWhisperer