Splunk Search

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

ddrillic
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

DalJeanis
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

jaustenfan
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

DalJeanis
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

ddrillic
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

ddrillic
Ultra Champion

The format of the line ending was off ; -)

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!