On 2/22/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
> A batch script or shell script can easily be written to do this.
>
> -Sheeri
>
> On 2/20/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
> > I've got some import scripts that are giving me trouble.
> >
> > Some MOFOs keep changing the format of th
A batch script or shell script can easily be written to do this.
-Sheeri
On 2/20/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
> I've got some import scripts that are giving me trouble.
>
> Some MOFOs keep changing the format of the data they give us, and
> sometimes I loose half the records. When
A little less dodgy is to write a VBA routine within Access to do the
filtering. Alternatively, if you don't want to trust access to do it, you
can write a VBScript or JScript routine and run it through the shell (yes,
Windoze has shell scripts, too)
There are all kinds of things you can do.
S
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 run
[EMAIL PROTECTED]
> Sent: Monday, February 20, 2006 11:21 PM
> To: mysql@lists.mysql.com
> Subject: mysqlimport, \r\n and \n
>
> I've got some import scripts that are giving me trouble.
>
> Some MOFOs keep changing the format of the data they give us,
> and sometimes
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they give us, and
sometimes I loose half the records. When this happens, I change the line
terminator from \r\n to \n ... or from \n to \r\n.
It's starting to get to me. Is there any way