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

[nikkkc]

Hi,

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

thanks in advance

[lydiapal_splunk]

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!

[renems · Accepted solution]

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

[jeffland]

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!