About gemtm

gemtm · ‎04-05-2023

I think the issue may be bigger than I expected, as the field "title" only picked out one song title from the list. Thank you regardless!

gemtm · ‎04-05-2023

{ mediaId="NowPlayingId39" title="On The Ground" artist="ROSÉ" album="" duration=0 trackPosition=39/50 image=null }

gemtm · ‎04-05-2023

I was trying to create a field name of "track" for the value I am trying to extract with the regex. I appreciate this may be an incorrect way to do it, as I do not usually use SPL. I've not seen the spath command, I'll take a look at this next. Thank you!

gemtm · ‎04-05-2023

I need some help to create a pie chart of songs using this raw data. The command I'm using is this: |rex (?<track>(?<=title=)"(.*?)".*$) |stats count by track This isn't showing a count of the songs, can anyone help me out to get this to work? Regex101 shows the regex as working to extract the song titles. Splunk does not give an error but the stats/viz panels show nothing. Example of raw log below. { mediaId="NowPlayingId39" title="On The Ground" artist="ROSÉ" album="" duration=0 trackPosition=39/50 image=null } { mediaId="NowPlayingId40" title="Rollercoaster" artist="Bleachers" album="" duration=0 trackPosition=40/50 image=null } { mediaId="NowPlayingId41" title="Ghost of You" artist="Mimi Webb" album="" duration=0 trackPosition=41/50 image=null }

Posts	4
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎04-05-2023

Online Status	Offline
Date Last Visited	‎04-05-2023 11:58 AM

Help with Regex for raw data to create pie chart?

Re: Regex for raw data to create pie chart

Re: Regex for raw data to create pie chart

Re: Regex for raw data to create pie chart

Help with Regex for raw data to create pie chart?

Join the Conversation

Help with Regex for raw data to create pie chart?

Re: Regex for raw data to create pie chart

Re: Regex for raw data to create pie chart

Re: Regex for raw data to create pie chart

Help with Regex for raw data to create pie chart?