CSV import
| User, date | Message |
|---|---|
|
Written by juyles
2 years ago Category: Import/Export 3 posts since Mon, 26 Sep 11 |
I am trying import a csv file from a utf-8 wordpress database. I get the first 3 lines in OK, one record. The other following records are not imported. My question is in the 'import text field' window what should be contained in the window 'lines terminated by'. I have looked for a symbol reference that would help me with this information, but so far no luck. I am new to heidi. Would appreciate any guidance or direction. Thanks Juyles |
|
Written by ansgar
2 years ago 3966 posts since Fri, 07 Apr 06 |
See http://dev.mysql.com/doc/refman/5.1/en/load-data.html Character Escape Sequence \0 An ASCII NUL (0x00) character \b A backspace character \n A newline (linefeed) character \r A carriage return character \t A tab character. \Z ASCII 26 (Control+Z) \N NULL |
|
Written by juyles
2 years ago 3 posts since Mon, 26 Sep 11 |
Thank you very much! Juyles |
|
Please login to leave a reply, or register at first. |