topic Re: Lookup table is invalid: Extra Commas? in Splunk Search

Lookup table is invalid: Extra Commas?

aapittts — Thu, 28 Feb 2013 20:48:38 GMT

I have a lookup table that I am getting an invalid error on. I believe its because there are extra commas in the data. The lookup table is two fields: codes and descriptions. The descriptions naturally have some commas in them. Is it possible that this is causing the invalid table error? If so, can I create custom regex for this issue?

Re: Lookup table is invalid: Extra Commas?

cramasta — Thu, 28 Feb 2013 21:16:58 GMT

I tried throwing extra commas in one of my lookups but it did not throw a error, it just messed up the data that the lookup provided.

Try putting text qualifiers "" around your fields like this

"item1", "some text with a , in it"
"item2", "another text with 2 ,, "

This will allow it to ignore commas that are part of the description

Re: Lookup table is invalid: Extra Commas?

aapittts — Thu, 28 Feb 2013 21:32:46 GMT

My issue wasn't commas but this is good to know.

Re: Lookup table is invalid: Extra Commas?

fu8R5juiNP64AKI — Wed, 15 May 2013 09:20:51 GMT

@aapitts What was your issue then? I am running into the same problem.

Re: Lookup table is invalid: Extra Commas?

barakreeves — Wed, 15 May 2013 13:41:43 GMT

I have run into the same issue before on a "simple" lookup table having only 2 fields and also had trouble finding the issue. This is what I did:

1- search for line break at the end of the line
2- search for lines not matching pattern "your data", "your data" such as a line with only 1 value or no value; sometimes Excel torques an innocent csv file and therefore, I try to do a quick eyeball check in my favorite text editor
3- check the limits.conf under the stanza "lookup" to see if it is a size violation

Wish you success!