Getting Data In

How to remove inner double quotes from json data??

AzmathShaik
Path Finder

Hello

i am trying to remove inner double quotes from json data

here is my sample data:

{"msg": "the message "is printed" here is " having extra double" quote " }

i want to remove the inner double quotes while indexing.
can any one help me in it

Thanks in advance.

0 Karma

gokadroid
Motivator

Try this answer which is exactly similar to what you are asking:

https://answers.splunk.com/answers/477298/how-to-remove-characters-in-my-json-raw-data-so-it.html#an...

Basically using the SEDCMD in your props.conf

0 Karma

AzmathShaik
Path Finder

sorry it didn't worked for me

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...