topic Re: How do you extract everything that ends with a certain word? in Splunk Search

How do you extract everything that ends with a certain word?

Cbr1sg — Thu, 10 Jan 2019 06:26:35 GMT

Hi all,

I have this line in the event log

ComputerName=sgp1ply1fe01.xxx

I want to extract only "sgp1" using rex, How can this be done?

Thanks

omerl — Thu, 10 Jan 2019 06:36:04 GMT

Is there a pattern to the rest of the word? Using ‘rex’ command should probably fit your need

Cbr1sg — Thu, 10 Jan 2019 07:14:40 GMT

yes the pattern is (name)plyxxx or (name)PLYxxx

bangalorep — Thu, 10 Jan 2019 07:20:06 GMT

Hello,
You could use a regex code like this
(?P<-extraction_name_>.*)ply

Cbr1sg — Thu, 10 Jan 2019 07:25:12 GMT

it works. Thank you!