Getting Data In

How to split multiple data of same column into different columns

shrutip123
Observer

I have one column with data entries like below -
column_1

a=123, b= 888, c=645,d=6328

a=6734, f=876, h=6666

 

I want the result as -

field_1             field_2
a                            123
b                             888
c                             654
d                             6328
a                              6734
f                                876
h                               6666


Thanks

0 Karma

to4kawa
Ultra Champion

| rex max_match=0 field=column_1 "(?<name>\w)=(?<data>\d+)"
| stats list(name) as field_1 list(data) as field_2

0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk &#43; Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...