CSV Import with only LF

2 posts
damemas's profile image damemas posted 5 years ago in Import/Export Permalink

Hi, as the csv files I need to import are from WebApplications, there is no CRLF as EOL, but only LF. I currently have to change the files using a tool. It would be nice if there would be the possibility to import CSVs with LF only. As a side note, not even Toad manages to import CSVs with only LF.

10392 posts
ansgar's profile image ansgar posted 5 years ago Permalink

Just tell HeidiSQL to use "\n" in the "Lines terminated by" setting:

Description

2 posts
damemas's profile image damemas posted 5 years ago Permalink

Ah, perfect. I simply overlooked that. Thanks for the very fast reply.

Please login to leave a reply, or register at first.