topic Re: Inputlookup: is it possible to use a semicolon separated CSV file? Can I configure the delimiter? in Getting Data In

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

nikkkc — Thu, 28 Jan 2016 16:17:52 GMT

Hi,

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

thanks in advance

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

jeffland — Thu, 28 Jan 2016 16:31:07 GMT

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!

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

renems — Wed, 03 Feb 2016 14:38:25 GMT

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

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

lydiapal_splunk — Mon, 13 May 2019 02:43:07 GMT

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!