Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
On Tue, 13 Feb 2001, Pat Sherrill wrote:
> When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
> CR/LF conversions will take place automagically. Alternatively some linux
> distributions have a utility to strip CR's from ASCII files and there is
> always old reliable vi .
>
> I hope this helps...
> Pat...
> [EMAIL PROTECTED]
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "Irmund Thum" <[EMAIL PROTECTED]>
> Cc: "Mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 13, 2001 7:31 AM
> Subject: Re: special characters messing me up
> > >>
> > >> ----- Original Message -----
> > >> From: "John W Ford" <[EMAIL PROTECTED]>
> > >> To: "Mysql" <[EMAIL PROTECTED]>
> > >> Sent: Tuesday, February 13, 2001 15:04
> > >> Subject: special characters messing me up
> > >>
> > >> > I can't figure out why my windows machine leaves "^M" character at
> the end
> > >> > of each line of code. This causes the file to be messed up when I
> put it
> > >> on
> > >> > the Linux server.
> > >> >
> > >> > It makes my perl interpreter look for a file named ^M after the very
> first
> > >> > line.
> > >> >
> > >> > #!/usr/sbin/perl
> > >> >
> > >> > also... what else I can't figure out is why this special character
> is
> > >> > sometimes hidden and sometimes visible in my Emacs program in
> Linux...
> > >> this
> > >> > is the program I used in which I found the problem.
> > >> >
> > >> > anybody know?
> > >> >
> > >> > John Ford
> > >
> > >this is a very old well-known Windows issue;
> > >you should use a text editor what can save your files in UNIX format:
> > >I guess every professinal editor has this option, see Textpad or
> > >Dreamweaver...
> > >
> > >--
> > >http://it97.dyn.dhs.org/
> > > Irmund Thum
> > >+49 179 6998564
> > >+49 6374 992541
> > >Content-Type: application/x-pkcs7-signature; name="smime.p7s"
> > >Content-Disposition: attachment; filename="smime.p7s"
> > >Content-Description: Kryptographische Unterschrift mit S/MIME
> > >
> > >Attachment converted: Ionia:smime.p7s (????/----) (00013E6A)
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
