Splunk Search

How to extract value from a string

Emily12
Explorer
  • Hi everyone

I need to extract value from a string before a specific character "_X"

 

Where X is any integer

Please note our string is like a_b_c_X

Could you please advice how can I do that 

Thank you in advance ☺️

 

Labels (2)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @Emily12,

you have to define a rule to use in a regex to identify your field.

So try something like this:

your_search
| rex "(?<your_field>.*)_\d"
| ...

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

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @Emily12,

you have to define a rule to use in a regex to identify your field.

So try something like this:

your_search
| rex "(?<your_field>.*)_\d"
| ...

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

Ciao.

Giuseppe

Emily12
Explorer

Hi @gcusello 

Thank you so much !!

It worked perfectly 😀

0 Karma
Get Updates on the Splunk Community!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...