topic Re: How to extract values? in Splunk Search

How to extract values?

valpravin — Fri, 13 Dec 2019 06:36:39 GMT

My Log Contains

"SeqNo":4433221,"T_CODE":"ABC","VALUE":983123456,"VALUE2":"0000000000",

I am in need of VALUE field which will display 983123456 as an output tried with this query

|rex VALUE="(?[^\d*])" |table VALUE

please help

Re: How to extract values?

vnravikumar — Fri, 13 Dec 2019 06:40:12 GMT

Check this

| makeresults 
| eval temp= "\"SeqNo\":4433221,\"T_CODE\":\"ABC\",\"VALUE\":983123456,\"VALUE2\":\"0000000000\", "
|rex field=temp "VALUE\"\:(?P<value>\d+)"

Re: How to extract values?

woodcock — Fri, 13 Dec 2019 11:10:21 GMT

Like this:

| makeresults 
| eval _raw= "\"SeqNo\":4433221,\"T_CODE\":\"ABC\",\"VALUE\":983123456,\"VALUE2\":\"0000000000\","

| rename COMMENT AS "Everything above generates sample event data; everything below is your solution."

| rex max_match=0 "(?<KEY_1>[^:\"]+)\"?:\"?(?<VAL_1>[^:\"]+)\"?,"
| eval _raw = mvzip(KEY_1, VAL_1, "=")
| kv

I named them this way for a reason; search for _KEY_1 on this page:
https://docs.splunk.com/Documentation/Splunk/latest/Data/Configureindex-timefieldextraction