Getting Data In

Inputlookup: is it possible to use a semicolon separated CSV file? Can I configure the delimiter?

nikkkc
Path Finder

Hi,

Is it possible to use a semicolon separated CSV file? Can I configure the delimiter?

thanks in advance

0 Karma
1 Solution

renems
Communicator

Jeffland is right: doesn't work.
The only workaround is modify your data accordingly. Don't forget to add whitespace after the comma.

View solution in original post

0 Karma

lydiapal_splunk
Splunk Employee
Splunk Employee

If there is anybody still looking at finding an alternative for using commas in a csv lookup file, because they CAN'T use commas, because their fields contain commas, GOOD NEWS:
You can use quotes as text delimiters and commas as field delimiters in the following fashion:

"field1","field2"
"example1 , that contains commas","something"
"example2",""
"","example3"

Splunk correctly extracts field value pairs!

0 Karma

renems
Communicator

Jeffland is right: doesn't work.
The only workaround is modify your data accordingly. Don't forget to add whitespace after the comma.

0 Karma

jeffland
SplunkTrust
SplunkTrust

I don't think so. You can't upload those via the GUI, and the ones you place in the lookups folder won't work right with semicolons.

Someone feel free to correct me if I'm mistaken!

Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...