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.

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

gcarson_splunk
Splunk Employee
Splunk Employee

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.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...