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!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...