I'm trying to upload a file to be a new lookup table and I get the following error -
What can it be?
Is this a plain csv file? Is it UTF-8 encoded? Take the file into something like notepad++ and turn on the "show invisible characters". see if there are cr/LFs at the end of the lines, or only CRs or LFs.
When converting/saving the excel file to csv in Excel, I chose the Windows csv option (something to do with extra characters being added otherwise). This solved the issue for me.
Is this a plain csv file? Is it UTF-8 encoded? Take the file into something like notepad++ and turn on the "show invisible characters". see if there are cr/LFs at the end of the lines, or only CRs or LFs.
-- see if there are cr/LFs at the end of the lines, or only CRs or LFs
That was the thing - thank you @DalJeanis
The format of the line ending was off ; -)
There are also some edge cases where if the csv column names have more than 4094 bytes characters Splunk will throw this error.
The solution in my case was to pre-process the csv and truncate the column names.