Splunk Search

How to remove "\n" character from string

guest_123
Engager

I have a serialized json string like below 

"{\n \"ID\": \"da419500-f6b4-11ec-8b49-025041000001\",\n \"Name\": \"splunk\",\n \"message\": \"demo\",\n \"tracePoint\": \"START\",\n \"priority\": \"ERROR\",\n \"flowName\": \"demo1\",\n \"timestamp\": \"2022-06-27T16:33:17.175289Z\",\n \"content\": {\n \"payload\": {\n \"message\": \"Hello world!\"\n }\n }\n}"

I need to remove all the "\n" form this string 

"{ \"ID\": \"da419500-f6b4-11ec-8b49-025041000001\", \"Name\": \"splunk\", \"message\": \"demo\", \"tracePoint\": \"START\", \"priority\": \"ERROR\", \"flowName\": \"demo1\", \"timestamp\": \"2022-06-27T16:33:17.175289Z\", \"content\": { \"payload\": { \"message\": \"Hello world!\" } } }" 

I tried rex field=myField mode=sed "s/\\n/ /g"  and also replace function both seems to be not helping 

 

 

 

Labels (2)
Tags (1)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

You should add one more \ to rex cmd like

| rex mode=sed field=myField "s/\\\n/ /g"

View solution in original post

isoutamo
SplunkTrust
SplunkTrust

You should add one more \ to rex cmd like

| rex mode=sed field=myField "s/\\\n/ /g"

guest_123
Engager

thank you @isoutamo 

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 ...