Splunk Search

What does the error "File has no line endings" for a lookup table means?

Ultra Champion

I'm trying to upload a file to be a new lookup table and I get the following error -

alt text

What can it be?

Tags (3)
0 Karma
1 Solution

SplunkTrust
SplunkTrust

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.

View solution in original post

0 Karma

New Member

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.

0 Karma

SplunkTrust
SplunkTrust

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.

View solution in original post

0 Karma

Ultra Champion

-- see if there are cr/LFs at the end of the lines, or only CRs or LFs

That was the thing - thank you @DalJeanis

Ultra Champion

The format of the line ending was off ; -)

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!