topic Re: How can I extract this pattern from my raw data using rex command? \"ProductAccountNumber\":\"5342534253425342\" in Splunk Search

How can I extract this pattern from my raw data using rex command? \"ProductAccountNumber\":\"5342534253425342\"

tanvi1g — Mon, 16 Oct 2017 03:50:18 GMT

Hi,

Can someone able to help me please.

I'm very new to using Splunk and most certainly to the rex command and regular expressions, so please bear with.

I'm trying to extract an ProductAccountNumber field from my raw data which is in the following format
{ \"ProductAccountNumber\":\"5342534253425342\" }

Could someone possibly tell me please how I may strip the actual ProductAccountNumber out of this line.

Many thanks and kind regards

Tanvi

Re: How can I extract this pattern from my raw data using rex command? \"ProductAccountNumber\":\"5342534253425342\"

inventsekar — Mon, 16 Oct 2017 05:22:42 GMT

Please check this -
| makeresults | eval _raw="{ \"ProductAccountNumber\":\"5342534253425342\" }" | rex field=_raw "ProductAccountNumber\\\"\:\\\"(?P<ProdAccNo>\d+)" | table _raw ProdAccNo

Re: How can I extract this pattern from my raw data using rex command? \"ProductAccountNumber\":\"5342534253425342\"

niketn — Mon, 16 Oct 2017 05:23:55 GMT

@tanvi1g, while the following Regular Expression worked on https://regex101.com

\\\"ProductAccountNumber\\\"\:\\\"(?<ProductAccountNumber>\d+)\\\"

I had to introduce some extra escape characters in Splunk. Following is a run anywhere search based on your data:

| makeresults
| eval _raw ="{ \\\"ProductAccountNumber\\\":\\\"5342534253425342\\\" }"
| rex "\\\"ProductAccountNumber\\\\\"\:\\\\\"(?<ProductAccountNumber>\d+)\\\\\""

Please try out this rex and confirm.