topic Re: Field-Extraction in Splunk Search

Field-Extraction

tmarlette — Thu, 10 Jul 2014 13:52:49 GMT

I have a some data I am attempting to extract and then do lookups on. I am attempting to extract the FID number, which is effectivley - "FID":FID#:property = < value >

Take a look at my entry:

FID:1022:5=18749,109 FID:1025:5=18752,109 FID:1029:8=0:0:0 FID:1066:5=0,101 FID:1179:1=1 FID:2000:2=1 FID:3001:6=  FID:6335:6=US4592001014 FID:6360:6=2005973 FID:6605:1=1.01755e+013 FID:6630:1=8.26677e-005 FID:7012:6=459200101 FID:8107:1=0 FID:17476:2=0 FID:17483:2=-1 FID:20001:6=ADdomain FID:20003:6=domain1 FID:20008:6=user1 FID:20052:6=DEP01

I attempted to use this REGEX extraction, but splunk doesn't recognize it: FID:(?<FID>\d+):\d+

I'm guess that either RegEx changed, or splunk changed somehow and I missed it, or i'm fat fingering something?

Thank you!

Re: Field-Extraction

somesoni2 — Thu, 10 Jul 2014 14:08:56 GMT

This is one log entry or 4? In both case, you need to extract all FID#?

Re: Field-Extraction

tmarlette — Thu, 10 Jul 2014 14:12:46 GMT

This is a snippet of one log entry, and I would need to extract ALL FID#'s from all log entries.

Re: Field-Extraction

richgalloway — Thu, 10 Jul 2014 14:15:17 GMT

So you want to get the values 1022, 1025, 1029, etc?

Re: Field-Extraction

tmarlette — Thu, 10 Jul 2014 14:22:27 GMT

Let's take the first part of the log entry:

FID:1022:5=18749

In this example, the number "1022" is what i'm looking to extract.

Re: Field-Extraction

somesoni2 — Thu, 10 Jul 2014 14:36:56 GMT

This works for me (give a multivalued field will all FID#)

Your base search | rex max_match=0 "FID:(?<FID>\d+):\d+="

Re: Field-Extraction

tmarlette — Thu, 10 Jul 2014 14:47:50 GMT

Thank you!!! This works very well! is there a way to do this in props.conf or transforms?

Re: Field-Extraction

somesoni2 — Thu, 10 Jul 2014 15:10:26 GMT

Yes sir. See this link.
http://answers.splunk.com/answers/11777/field-extraction-into-multivalue-field

Re: Field-Extraction

tmarlette — Thu, 10 Jul 2014 16:14:20 GMT

Thank you!!