Splunk Enterprise Security

Adding Threat Intelligence feed into Splunk ES in CSV format

JakeInfoSec
Explorer

I'm currently trying to upload a malware feed into Threat Intelligence Management.

The feed itself is being pulled from the following URL: https://bazaar.abuse.ch/export/csv/recent/

The issue is that while it is in CSV format, the values themselves are also encapsulated by quotes, so they are being imported into the file_intel like the following.

JakeInfoSec_0-1650639667839.png

To extract out the actual values since they are surrounded by quotes I put together a regular expression under "Extracting regular expression" which works on regexr and regex101, but this regular expression does not appear to be getting used as the values in the lookup still look like the above.

JakeInfoSec_0-1650643252401.png

 

Here is what the csv looks like.

JakeInfoSec_2-1650640799840.png

Is there a setting I am missing that is causing the regex to not be utilized?

Labels (1)

BenjaminAbben
SplunkTrust
SplunkTrust

maby this will work:? 

@the parsing tab do the following extracting reg expr: ([^\"\,]+)

 

0 Karma

BenjaminAbben
SplunkTrust
SplunkTrust

Oh wait,, after some messing around place the + 1 spot to the left like so:

\b([^\"\,]+)\b

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

Hello Splunkers,  We’re excited to kick off a Splunk Dashboard contest! We know that dashboards are a primary ...

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...