Splunk Search

Excluding multiple slashes throughout regex capture string

splunkrush
Engager

Trying to figure out how to extract a field using regex to capture the entire string.  Only problem is there are a bunch of slashes throughout.  Sometimes one, sometimes 3, etc.  I've tried variations of commands I found in the documentation but no luck.  is this possible?

Example String of Field I want to extract with all the context appended to one another minus the slashes:

\"\\\"Field1\\\":\"context"\\\",\\\:"\"context"\\\",\\\:"\"context"\\\",\\\:"\"context"\\\",\\\:"\"context"\\\"context\\\\\\\context\\\\\\\\Field2

Want it to be extracted like this: Field1="context","context" etc so slashes are eliminated.  Appreciate any help.

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

You can simply remove the backslashes like this

| rex field=_raw mode=sed "s/\\\//g"

However, I suspect this is not what you want, but what you want it unclear since all your data is "context". Are you expecting Field1 to be "context,context,context", or something else?

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

You can simply remove the backslashes like this

| rex field=_raw mode=sed "s/\\\//g"

However, I suspect this is not what you want, but what you want it unclear since all your data is "context". Are you expecting Field1 to be "context,context,context", or something else?

splunkrush
Engager

Thank you, that did the trick.  I was trying to do everything through the field extraction page, but using 'sed' worked better.  It kept all the context I needed and eliminated all the slashes.

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...

From GPU to Application: Monitoring Cisco AI Infrastructure with Splunk Observability ...

AI workloads are different. They demand specialized infrastructure—powerful GPUs, enterprise-grade networking, ...

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...