r'
Cc: [EMAIL PROTECTED]
Subject: RE: White Space
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris
Just use something else beside commas to delimit your file. I have a
file that I need to regularly import that has commas, tabs and returns
in the data. I delimit the fields with ^^ and the records with ~~.
You can tell MySQL what the delimiters are when you import the data.
On Feb 20, 2004, at
On 20 Feb 2004 at 14:55, Dan Nelson wrote:
> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.
But note that, unlike similar functions in some languages, the MySQL
TRIM() function removes spaces (ASCII 32 characters), not whitespace
(whic
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris Fossenier
> Cc: [EMAIL PROTECTED]
> Subject: Re:
In the last episode (Feb 20), Chris Fossenier said:
> What is the best way to deal with white space in a mysql database?
>
> What I'm talking about is trailing spaces in larger fields. We
> receive data in fixed width format, so when you import it, you get a
> bunch of trailing white spaces that
