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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...