Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

CSV Import with only LF

damemas's profile image damemas posted 4 days 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.

ansgar's profile image ansgar posted 4 days ago Permalink

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

Description

damemas's profile image damemas posted 3 days ago Permalink

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

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