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!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...