How to extract value from a string

[Emily12]

• 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 ☺️

[gcusello · Accepted solution]

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]

Hi @gcusello 

Thank you so much !!

It worked perfectly 😀