Splunk Search

DELIM not capturing full value

ltranarris
New Member

I'm using DELIM to extract colon separated KV pairs separated by a comma.

DELIMS = ",", ":"

This is somewhat working. The problem I'm noticing is that it's not capturing the full value if there's an additional comma. Here's an example. The UserAgent stops at (KHTML,.

Any suggestions?

[06/06 09:53:13.741][ec-46] I [                         track: 169] [1.2.3.4]: IP: 5.6.7.8, SearchId: 46108594, ReferenceNumber: 46108594, LastName: XnameX, DatetimeSent: 2019-06-05, DateTimeLookUp: 2019-06-06T09:53:12.919, TransactionStatus: READY_FOR_PICKUP, SendCountry: USA, ReceiveCountry: MEX,  UserAgent: Mozilla/5.0 (Linux; Android 9; SAMSUNG SM-N960U Build/PPR1.180610.011) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/9.2 Chrome/67.0.3396.87 Mobile Safari/537.36, Application: ABC, Failed: False, OnlineTransaction: false, SendAmount: 60.00, SendCurrency: USD 
Tags (1)
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...