Splunk Search

rex

Deku2345
Observer

How to split a text like ""Liam John" "Grayson Roy" "Olivia"" into names filed using eval and text.

names:

Liam John
Grayson Roy
Olivia

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Deku2345,

you can use the rex command, something like this:

| rex "\"(?<last_name>[^ \"]+)\s|\"(?<first_name>[^ \"]+)"

that you can test at https://regex101.com/r/LYEhns/1

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Splunk MCP & Agentic AI: Machine Data Without Limits

  Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...