topic Re: commas in lookup tables in Splunk Search

commas in lookup tables

stephen123 — Mon, 19 Nov 2012 11:57:49 GMT

hi, I am using a look-up table, however some of the fields have commas in them. - as you would expect these do not match. Any idea how to get around this,

I have tried adding a \ before the comma but this does not help
I can not remove the comma as this will not match the data

Thanks

Re: commas in lookup tables

MHibbin — Mon, 19 Nov 2012 12:25:55 GMT

If you can edit the CSV that you are using as a lookup directely, have you tried including the offending field in quotations (e.g. "). For example:

field0, field1, field2
efuieb, "foo,bar", blah
inevei, "foo", blah

Hope this helps.

MHibbin

Re: commas in lookup tables

stephen123 — Mon, 19 Nov 2012 12:47:08 GMT

awesome - thanks

Re: commas in lookup tables

HeinzWaescher — Wed, 20 Nov 2013 10:34:38 GMT

Hi,

I've got another comma problem with a lookup. I would like to create a lookup for field values in the eventdata like Test,A, which i want to replace with a new value.

My lookuptable looks like this:

"Test,A" - New Value

I used the quotes to achieve, that the value is not splitted up in the lookup. But then I'm not able to use the lookup, because there is no match. The values in the eventdata don't have quotes...

Any ideas how to achieve my goal?

Thanks, Heinz