Importing in a CSV file help

[Tread42]

I'm trying to import in a csv file to MySQL. There is only one field in this file but I can't find the delimeter using phpMyAdmin.

The field is layed out like this

"11111"
"22222"
"33333"

And such, how do I code in that the fields are delimeted by a "return"? Is there a special character reference? If it was a , it'd be easy enough to put that in the delimeter value but with a return it will not take it.

Thanks in advance for any help
Tread42

 

[gerrygerry]

use "\r\n", "\n", or "\r" as the line delimeter... it varies depending on your OS. -gerrygerry
Go To

http://quickfreewebsite.com!

 

[Tread42]

Thanks gerrygerry. Just one question what does \r and \n stand for? i'm taking it \r is for \return?

Regards,
Tread42

 

[gerrygerry]

\r = carriage return
\n = new line

Also...
 Windows uses both \r\n 
 Unix uses \n 
 Mac uses \r

Glad to help! -gerrygerry
Go To

http://quickfreewebsite.com!