Splunk Search

Extracting field value gets encoded. Why?

jkim34
New Member

I have extracted value from the message log. So I have custom field with its value.
In the log, it displays "* myName=J&K *"
The extract field is myName, and it's value is now "J\u0026K".
Even when I export this in PDF or CSV, encoded value gets displayed.

Why is this occurring, and is there way to prevent automatic encoding?

0 Karma

p_gurav
Champion

Hi jkim34,

Could you try this regex "myName=(?P[^,\s*(next*)]+)"

0 Karma

jkim34
New Member

Hi p_gurav,
This don't seem to work. Also other field-value do contain white spaces, commas, etc.
This issue so far seems to be an issue with character & < >
At this point, I'm wondering if this is OOTB issue, or something that needs to be done inside configuration file..

0 Karma

ddrillic
Ultra Champion

-- This issue so far seems to be an issue with character & < >
Why does it feel like your data is being treated like XML data? ; - )

0 Karma

jkim34
New Member

You are right. Maybe I should revise my question a bit 🙂

0 Karma

p_gurav
Champion

My bad, Try this:

myName=(?P<myname>[^,\s*(next*)]+)
0 Karma

jkim34
New Member

Sorry, I've actually tried this with bracket <>

0 Karma

p_gurav
Champion

Could you please tell me exact search command you are running and one whole sample event?

0 Karma

jkim34
New Member

Besides regex I stated above, I have following additional information:
Log Message=Form [myAddress=1 Main St., myName=J&K, myPhoneNumber=111-111-1111]
Search Command=search term | table myName

0 Karma

somesoni2
Revered Legend

How are you extracting the field? Can you share configuration/regex for it?

0 Karma

jkim34
New Member

Hi, regex is something like below:

(?<=myName=){1}(?P<myName>.+)(?=, nextKeyWord)

Where it looks for the preceding regex just before the value that I'm extracting for, and until it sees , nextKeyWord

0 Karma
Get Updates on the Splunk Community!

Splunk and TLS: It doesn't have to be too hard

Overview Creating a TLS cert for Splunk usage is pretty much standard openssl.  To make life better, use an ...

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...

Splunk Enterprise Security: Your Command Center for PCI DSS Compliance

Every security professional knows the drill. The PCI DSS audit is approaching, and suddenly everyone's asking ...