topic Re: How to extract multiple values from output to create new column in table with associated values in Splunk Search

How to extract multiple values from output to create new column in table with associated values

najaplit — Thu, 08 Apr 2021 14:29:51 GMT

Hello,

I have a search query that produces a value similar to below. What i am trying to accomplish is to extract the "Data", "Time", and "Notes" section and to output those values to a table with each in a separate column. What would be an efficient way to accomplish this? I am seeing some regex syntax fines but not as familiar with it. Any help is appreciated. Thanks!

----------------------------------------

Value:

CompName: XXX XXX Type: XXX EmpName: XXX Date: XX-XX-XXXX Time 9:00AM Notes: XXXX

Re: How to extract multiple values from output to create new column in table with associated values

ITWhisperer — Thu, 08 Apr 2021 15:08:19 GMT

I modified your example show it working for PM times and included a colon after Time to make it consistent, but this is an example of how you might approach it

| makeresults | eval _raw="CompName: XXX XXX Type: XXX EmpName: XXX Date: 23-03-2021 Time: 9:00PM Notes: WXYZ" | rex "Date:\s(?<date>[^\s]+)\sTime:\s(?<time>[^\s]+)\sNotes:\s(?<notes>.*)" | eval _time=strptime(date." ".time,"%d-%m-%Y %I:%M%p")