topic Re: extracting log data in Splunk Search

extracting log data

kavyatim — Mon, 28 Apr 2014 07:00:12 GMT

Hi,
i have data in following format
PacketPos[503081044] PosInPacket[ 38] NALlength[11634] NAL[98983] Type[Non IDR slice]FrameType[P] DecodingIndex[32207] PresentationIndex[32211] POC[32262] frame_num[83] Structure[TopField] SPSid[0] PPSid[0] PTS[217794471] DTS[217785462]
how will i extract fields and their values using regex. .

Kindly help me in writing regex for this. . .

Thanking in advance,

Re: extracting log data

gfuente — Mon, 28 Apr 2014 07:58:26 GMT

[hide preview] 49 characters / 6 words
Hello

Try using this command:

... | rex "^\w+(?<PacketPos>\[[^\]]+\])\s\w+(?<PosInPacket>\[[^\]]+\])\s\w+(?<NALlength>\[[^\]]+\])\s\w+(?<NAL>\[[^\]]+\])\s\w+(?<Type>\[[^\]]+\])\s?\w+(?<FrameType>\[[^\]]+\])\s\w+(?<DecodingIndex>\[[^\]]+\])\s\w+(?<PresentationIndex>\[[^\]]+\])\s\w+(?<POC>\[[^\]]+\])\s\w+(?<frame_num>\[[^\]]+\])\s\w+(?<Structure>\[[^\]]+\])\s\w+(?<SPSid>\[[^\]]+\])\s\w+(?<PPSid>\[[^\]]+\])\s\w+(?<PTS>\[[^\]]+\])\s\w+(?<DTS>\[[^\]]+\])" |...

Hope it helps

Regards

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 08:38:19 GMT

Hi ,

Thank you very for your answer. .
Getting below error ,can you correct the error.
Regex - Cannot find regex reference: ^, in regex: '^w+(?[[^]]+])sw+(?[[^]]+])sw+(?[[^]]+])sw+(?[[^]]+])'

Re: extracting log data

gfuente — Mon, 28 Apr 2014 08:40:31 GMT

Try again, there were missing backslash

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 08:57:45 GMT

Tried but not able to make out what is missed

Re: extracting log data

gfuente — Mon, 28 Apr 2014 09:04:54 GMT

That regex works for the example you provided. What problem do you have now?

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 09:43:26 GMT

Thank you very much for your answer i am able to extract . . .

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 10:27:35 GMT

i will i extract without [ ] . ..

for example for field Structure, values are [small],[big],[medium]. ..
how to extract without brackets

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 10:36:27 GMT

I mean to say I dont want to extract brackets with values,using above regex I am able to extract values with in brackets. .
how will i extract only values without brackets

Re: extracting log data

gfuente — Mon, 28 Apr 2014 10:38:15 GMT

Hello you just need to move the brackets outside the capturing group like:

\w+\[(?[^\]]+)\]\s

Re: extracting log data

kavyatim — Mon, 28 Apr 2014 11:23:08 GMT

yes got it. .thank you very much