terminated by '\r'....

[Kalin Mintchev]

hi all,

load data infile doesn't work with     escaped by '\\'   line 
terminated by '\r'
the problem is the '\r' . doesn't work with '\r\n' either.
if i replace the \r with \n in the the text file itself then it works 
fine the files i'm trying to load are tab delimited txt files generated 
by xcel...
they dont have '\r\n' at the and of the line - all they have is '\r'...
what should i specify as the end of the line to make it work as a mysql 
command without using sed....

thanks..