Knowledge Management

Splunk Extract Command to process single or double quotes

youngc_splunk
Splunk Employee
Splunk Employee

Hello Gurus!

I am sure some people may have run in to this.   I am using extract command to parse fields from multi line unstructured event, but the data values are encapsulated by single quotes.

Here is the example :

====EVENT 1========

2021-09-08 00:00:00 ABC status - performance event
    name : 'James Bond'
    address : 'USA'
    age : '100'
    occupation : 'spy'
performance event END

==================

So the the following event, I am using transforms to 

transforms.conf

[performance_data]
DELIMS = "\r\n", ":"

So above transforms partially works.  The problem is the values has single quote ' encapsulated.

Like this

Field name "name"  with value "'James Bond'".   single quote included.  How can I get rid of the single quote?

0 Karma
Get Updates on the Splunk Community!

Announcing the Expansion of the Splunk Academic Alliance Program

The Splunk Community is more than just an online forum — it’s a network of passionate users, administrators, ...

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

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

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...