topic Re: How do you write a Regular expression in props.conf for only one field? in Splunk Search

How do you write a Regular expression in props.conf for only one field?

rakeshksingh — Wed, 28 Nov 2018 07:07:10 GMT

Hi All,

How do I write a regular expression in props.conf for only one field ?

like rex field=ab "regex"

thanks
Rakesh

Re: How do you write a Regular expression in props.conf for only one field?

dkeck — Wed, 28 Nov 2018 07:40:12 GMT

HI,

if you want to add a search time field extraction within props.conf, just use EXTRACT

[your-sourcetype]    
EXTRACT-<class> = [<regex>|<regex> in <src_field>]
    * Used to create extracted fields (search-time field extractions) that do
      not reference transforms.conf stanzas.

for reference see : http://docs.splunk.com/Documentation/Splunk/7.2.1/Admin/Propsconf

Please keep in mind that this will require a refresh/debug= http[s]://[splunkweb hostname]:[splunkweb port]/debug/refresh

Re: How do you write a Regular expression in props.conf for only one field?

rakeshksingh — Wed, 28 Nov 2018 08:46:42 GMT

tried but no luck.

[your-sourcetype]

EXTRACT-ab1 = [(?{.) in ab]

Could you take a look and guide me which part i am missing ?

Re: How do you write a Regular expression in props.conf for only one field?

rakeshksingh — Wed, 28 Nov 2018 10:15:52 GMT

tried below also but no luck.

EXTRACT-ab1 = (?{.) in ab

ab as field name

and tried with props and conf but no luck

[mysourcetype]

REPORT-myextract = myextract

Then in transforms.conf:

[myextract]

SOURCE_KEY = ab

REGEX = regex

Re: How do you write a Regular expression in props.conf for only one field?

dkeck — Wed, 28 Nov 2018 10:24:26 GMT

Do you have an example of the data?

Did you test your regex? for example here: https://regex101.com/

Syntax for EXTRACT should look like this :

EXTRACT-threadid = (?<threadid>[0-9A-Fa-f]+)\s+

Re: How do you write a Regular expression in props.conf for only one field?

FrankVl — Wed, 28 Nov 2018 10:28:04 GMT

Those square brackets shouldn't be there.

Re: How do you write a Regular expression in props.conf for only one field?

FrankVl — Wed, 28 Nov 2018 10:29:54 GMT

Your EXTRACT doesn't look like a valid regex (but perhaps some characters went missing by posting it here without using the post as code option (use the 101010 button in the message editor toolbar, or enclose the code in `)

Your transforms is impossible to comment on without posting the actual regex. Does that include named capturing groups (e.g. (?<fieldname>regex)? Otherwise you also need a FORMAT setting to specify what field(s) the capture group(s) should be mapped to.

Re: How do you write a Regular expression in props.conf for only one field?

rakeshksingh — Wed, 28 Nov 2018 17:59:21 GMT

Thanks for response,

in ab field, data is on json format