search

ceefour / hadith-islamware

Hadith database from Islam Ware
https://www.islamware.com/app/downloads
The Unlicense
121 stars 48 forks source link

what are the Field and Row Terminators? #1

Closed mhashim6 closed 7 years ago

mhashim6 commented 7 years ago

I want to export the .csv file to a SQL database file, but I don't know the Field and Row Terminators.

ceefour commented 7 years ago

Hi, @mhashim6 for any CSV file you found you can usually inspect this visually:

https://raw.githubusercontent.com/ceefour/hadith-islamware/master/hadith-sunan-al-darimi.utf8.csv image

So you can see the field terminator is "|" and row terminator is LF (newline).

mhashim6 commented 7 years ago

the line (row) terminator in this file is \n0| though.