| Daniel Kasak 2006-02-25, 9:43 am |
| George Law wrote:
> Daniel,
>
> What about just running your import file through dos2unix before piping
> it to mysql?
>
> That way, it would leave \n alone (since that is unix format) and
> replace any occurrances of
> \r\n with plan old \n.
>
I could think of a lot of things I could do if this were all running on
Linux.
Unfortunately the import routine is being triggered from MS Access ...
and come to think of it, I'm using 'load data infile' and not
'mysqlimport', but anyway, you get the idea. AFAIK there is no way to
trigger anything useful via ODBC. I could write a Perl script, chuck it
in my cgi-bin folder, and opening Firefox from Access, passing the
script some pointers to the file. But that's dodgy. I suppose while I'm
working with Access I'd better get used to dodgy solutions, eh? ;-)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting
.com.au
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|