Can you please help how to return below splunk result into Table format.
Employer details name Jon smith empid:4538938
Employer details name Mac Stone empid:4538939
Employer details name David smith empid:4534458
splunk Output in table format
Name Empid
Jon smith 4538938
Mac Stone 4538939
David smith 4534458
If you don't already have anything parsing the information into fields, then you could apply a regex with rex
to extract data into fields, and then plot as a table with the table
command:
| rex field=Message "Employer details name (?<name>.*) empid:(?<empid>\d+)"
| table name empid