Getting Data In

True-Client-IP=[12.34.56.78]

daniel333
Builder

All,

I have some header information coming through like so
True-Client-IP=[12.34.56.78]

I'd like to correct the data as it's ingested to be
True-Client-IP=12.34.56.78

Dropping the "[]" from around the IP address. Not sure where to start. I feel like I should be able to use SEDCMD inside props.conf but I am not sure how that would look.

0 Karma

jhall0007
Path Finder

This is old post, but one suggestion would be to create a custom field in props

Search Head props.conf:
[]
EXTRACT-true_ip = True-Client-IP=[(?(\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}))]

aakwah
Builder

Minor modification, Extract should be in capital letters,

EXTRACT-true_ip = True-Client-IP=[(?(\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}))]
0 Karma

jhall0007
Path Finder

Thanks you.

0 Karma

somesoni2
Revered Legend

Can you provide the complete event ? Just to ensure the SEDCMD for this doesn't affect any other portion of the data.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

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