Getting Data In

How to split String sentence into one row?

tahasefiani
Explorer

Hello,

I have a fields in my index named MESSAGE.

[BBB] ProcessGenererIdentifiantLMKRImpl/genererIdentifiantLMKR - CHECK OK - codeClient= 98451635- codeCanal= III- identifiantLMKR= JHF7UNJK6ZJNEZFI0873NFI373UBF389, nomMethode=genererIdentifiantLMKR

The result that i want is

alt text

0 Karma
1 Solution

to4kawa
Ultra Champion
| makeresults 
| eval message="[BBB] ProcessGenererIdentifiantLMKRImpl/genererIdentifiantLMKR - CHECK OK - codeClient= 98451635- codeCanal= III- identifiantLMKR= JHF7UNJK6ZJNEZFI0873NFI373UBF389, nomMethode=genererIdentifiantLMKR"
| eval _raw=split(replace(replace(message," ",""),",","-"),"-")
| kv
| table codeClient identifiantLMKR

View solution in original post

kamlesh_vaghela
SplunkTrust
SplunkTrust

@tahasefiani

Can you please try this?

YOUR_SEARCH | rex field=MESSAGE "codeClient=\s(?<codeClient>\d+[^-]).*identifiantLMKR=\s(?<identifiantLMKR>\w+)"  
| table codeClient identifiantLMKR

Sample search:

| makeresults 
| eval MESSAGE="[BBB] ProcessGenererIdentifiantLMKRImpl/genererIdentifiantLMKR - CHECK OK - codeClient= 98451635- codeCanal= III- identifiantLMKR= JHF7UNJK6ZJNEZFI0873NFI373UBF389, nomMethode=genererIdentifiantLMKR" 
| rex field=MESSAGE "codeClient=\s(?<codeClient>\d+[^-]).*identifiantLMKR=\s(?<identifiantLMKR>\w+)"  
| table codeClient identifiantLMKR
0 Karma

tahasefiani
Explorer

it returns me empty columns

0 Karma

to4kawa
Ultra Champion
| makeresults 
| eval message="[BBB] ProcessGenererIdentifiantLMKRImpl/genererIdentifiantLMKR - CHECK OK - codeClient= 98451635- codeCanal= III- identifiantLMKR= JHF7UNJK6ZJNEZFI0873NFI373UBF389, nomMethode=genererIdentifiantLMKR"
| eval _raw=split(replace(replace(message," ",""),",","-"),"-")
| kv
| table codeClient identifiantLMKR
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

At .conf26, Don’t Just See What’s Next. Help Shape It at Innovation Labs.

Long before a new capability reaches the keynote stage, it begins as an idea waiting to be tested. At ...

Forwarder Topology Guidance: Intermediate HF vs Intermediate UF

Why Universal Forwarders Should Not Be Used as Intermediate Forwarders A practical Splunk forwarding topology ...

Data Management Digest – August 2026

Data Management Digest   Welcome to the August 2026 edition of Data Management Digest! August was a big month ...