How to extract certain words and exclude words from string?

[marinella26]

Hello,

I want to extract certain words only and exclude that comes after numbers.

ex.
Apple12ed
Apple456ppp
Orange234iw
Banana7ye

expected result:
Apple 
Orange 
Banana 

I have tried below, but the each string has different numbers and words, so the result is not correct.

| eval Fruits = substr(Fruits, 1, len(Fruits)-4)

incorrect Result:
Apple
Apple45
Orange2
Banan

Thanks in advance.

[marinella26]

There are more than 100 strings, so it is not ideal to use <eval> to create each strings.

[gcusello · Accepted solution]

Hi @marinella26 ,

I suppose that the words to extract are in a field, so you can use the rex command to extract the word in each field, something like this:

<your_Search>
| rex field=your_field "^(?<word>[A-Za-z]*)"
| table word

Ciao.

Giuseppe

[duesser]

Maybe using

^(?P<word>[a-zA-Z]+)(?=\d)

would be more exact, as it does not return an empty match on strings that do not start with a letter such as "_Apple". Furthermore, it makes sure the word is followed by a digit and does not match "Apple_" for example.

[marinella26]

@gcusello It worked!! Thank you so much.