Getting Data In

Convert a string to table in splunk

bharat149
Explorer

Hi All i have result in the below format :
"From abc customerId YETNAKCNK, operation create,consumedUnits 0"
"From abc customerId YETNAKCNJ, operation update,consumedUnits 2"

I have to convert the below data to the following format : 
customerId               operation           consumedUnits

YETNAKCNK.             create                           0

YETNAKCNJ               update                          2

Tags (1)
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@bharat149 

Can you please try this?

YOUR_SEARCH
| rex field=_raw "customerId (?<customerId>.*),\soperation\s(?<operation>.*),consumedUnits\s(?<consumedUnits>.*)"
|table customerId operation consumedUnits

 

Sample Search

| makeresults 
| eval event="From abc customerId YETNAKCNK, operation create,consumedUnits 0|From abc customerId YETNAKCNJ, operation update,consumedUnits 2" 
| eval event=split(event,"|") 
| mvexpand event 
| rename event as _raw
| rex field=_raw "customerId (?<customerId>.*),\soperation\s(?<operation>.*),consumedUnits\s(?<consumedUnits>.*)"
|table customerId operation consumedUnits

View solution in original post

0 Karma

bharat149
Explorer

and if i want to apply filter for the customer Id

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

jus add
| where customerId="YETNAKCNK"

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@bharat149 

Can you please try this?

YOUR_SEARCH
| rex field=_raw "customerId (?<customerId>.*),\soperation\s(?<operation>.*),consumedUnits\s(?<consumedUnits>.*)"
|table customerId operation consumedUnits

 

Sample Search

| makeresults 
| eval event="From abc customerId YETNAKCNK, operation create,consumedUnits 0|From abc customerId YETNAKCNJ, operation update,consumedUnits 2" 
| eval event=split(event,"|") 
| mvexpand event 
| rename event as _raw
| rex field=_raw "customerId (?<customerId>.*),\soperation\s(?<operation>.*),consumedUnits\s(?<consumedUnits>.*)"
|table customerId operation consumedUnits
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...