i have data something like this
input:
firstname=value1,lastname=value2,email=value3,address=value4.. etc
firstname=value11,lastname=value12,email=value13,address=value14.. etc
firstname=value12,lastname=value13,email=value14,address=value15.. etc
output:
firstname lastname email address
value1 value2, value3, value4
value11 value12, value13, value14
value12 value13, value14, value15
i want to extract this data into a table with keys as column headers. Please note these keys are dynamic and it can have any names.
i tried
search | extract pairdelim="," kvdelim="="
but not sure how to put them into a table format. any inputs?
| table *
thank you.