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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...