topic Re: How to extract a part of a field? in Splunk Search

How to extract a part of a field?

reschal — Fri, 15 Dec 2017 08:55:38 GMT

Hey,

i have got a field extraction called mail. So i get different kind of mails as output.

But it appears the following problem: All the mail adresses have a "." at the end and i want to remove the ".".

For example: "xy.z@yahoo.com." shall be "xy.z@yahoo.com"

I tried to solve the problem by extracting the expression without the "." but it won't work.

|rex field=mail "(?<mail>[\s]+)-."

Thanks for your help!

Re: How to extract a part of a field?

mayurr98 — Fri, 15 Dec 2017 09:17:53 GMT

Try this

| rex field=mail "(?P<mail>[^\s]+)\."

Let me know if it helps!

Re: How to extract a part of a field?

Yunagi — Fri, 15 Dec 2017 09:22:29 GMT

If you really want to change the field with a Splunk search, then try the following:

| eval mail=substr(mail,0,len(mail)-1)

However, I think the better approach is to improve the actual field extraction. Can you provide the field extraction under Settings/Fields/Field extractions?

Re: How to extract a part of a field?

reschal — Fri, 15 Dec 2017 09:52:58 GMT

It works. Thanks very much 🙂