While I'm trying to upload my csv file as lookup, encountering the error like - "Encountered the following error while trying to save: File has no line endings"
I had tried by removing extra space and special characters from the header but still facing this issue. Along with that I had tried saving as different format of csv's line utf-8, csv-ms doc etc., but NO LUCK
How was the file created? Have you tried changing the line endings (notepad++ can do this, perhaps other editors can as well)?
Basically we export from Airtable as a csv.
I changed in notepad++, view->show symbols-> show all characters, and edit->EOL Conversion->Windows Format. but that doesn't work.
>>> Basically we export from Airtable as a csv.
Just after getting the above CSV file, Could you pls try to upload to Splunk(without notepad++ tasks).
if the above CSV file upload fails, open the file in notepad(hoping that the file is not big enough) and inspect manually, if all looks good, maybe pls try to upload once again.
maybe could you copy paste a screenshot of the error(after editing/masking/hiding sensitive details), thanks.
I had tried the way you told but I got the same error as above.
These are the last two values of my csv file in notepad + +
Does every line should have CRLF ?
Rather than 2 events, I see 11. Eight of them contain a single value and the remainder contain different numbers of values.
A well-formed CSV file will have the same number of values in each event. Any values with embedded CRLFs must be enclosed in quotation marks.
Is the CSV file well-formatted? Missing quotes or unescaped embedded quotes (or commas) may affect how the file is loaded.