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!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...

Updated Data Management and AWS GDI Inventory in Splunk Observability

We’re making some changes to Data Management and Infrastructure Inventory for AWS. The Data Management page, ...