Splunk Search

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

tanvi1g
New Member

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

Tags (2)
0 Karma

niketn
Legend

@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.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

inventsekar
SplunkTrust
SplunkTrust

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

alt text

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...