replace a chunk peace of string

Hi,

After ahavuing inseted my vvalues from a local file via : load infile ...
I notice a strange peace of string in my fnal field :
like :
"kkv850
"
select hex("kkv850
")
->
6B6B763835300D0A
select hex("a
")
->
610D0A
always 0D0A at the ends :(

I' m on windows, and i didn't manage to destroy this peace of string :(
trim() doesn't work ...

Thanks.

* Thus wrote ada (david_devidal@yahoo.fr):
> select hex("a
> ")
> ->
> 610D0A
> always 0D0A at the ends :(
>
> I' m on windows, and i didn't manage to destroy this peace of string :(
> trim() doesn't work ...

What do you mean trim() doesn't work?


Curt
--
If eval() is the answer, you're almost certainly asking the
wrong question. -- Rasmus Lerdorf, BDFL of PHP

> What do you mean trim() doesn't work?

trim is a basic function that remove spaces on the left and the right at the
string :
" abc "->"abc"

* Thus wrote ada (david_devidal@yahoo.fr):
> > What do you mean trim() doesn't work?
>
> trim is a basic function that remove spaces on the left and the right at the
> string :
> " abc "->"abc"

trim() removes more than spaces, please read:
http://php.net/trim


What I meant in my original post was how are you using trim() that
doesn't make it work? trim() *will* fix your problem.


Curt
--
If eval() is the answer, you're almost certainly asking the
wrong question. -- Rasmus Lerdorf, BDFL of PHP