Field-Extraction

[tmarlette]

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!

[somesoni2 · Accepted solution]

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

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

[tmarlette]

Thank you!!

[somesoni2]

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

[tmarlette]

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

[tmarlette]

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.

[richgalloway]

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

[tmarlette]

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

[somesoni2]

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