Splunk Search

extracting log data

kavyatim
Path Finder

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,

Tags (1)
0 Karma
1 Solution

gfuente
Motivator

[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

View solution in original post

gfuente
Motivator

[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

kavyatim
Path Finder

yes got it. .thank you very much

0 Karma

gfuente
Motivator

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

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

0 Karma

kavyatim
Path Finder

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

0 Karma

kavyatim
Path Finder

i will i extract without [ ] . ..

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

0 Karma

kavyatim
Path Finder

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

0 Karma

gfuente
Motivator

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

0 Karma

kavyatim
Path Finder

Tried but not able to make out what is missed

0 Karma

gfuente
Motivator

Try again, there were missing backslash

0 Karma

kavyatim
Path Finder

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+(?[[^]]+])'

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...