>>>It is ASCii 160. how to get rid of it? I tried STRTRAN() with TRIM() but it did not fix it.
>>>
>>>Ooops. yes it worked. REPLACE field WITH alltRIM(STRTRAN(field,chr(160),""))
>>
>>ALLTRIM in VFP9 has additional parameter (trim character).
>>
>>But it doesn't work with char(160) as parsing character and I don't see anything regarding this in Help.
>
>I just tried it in VFP 9 SP02 with the hotfixes applied and it works fine; try this:
>
>
>lcTest = "Test" + CHR(160)
>?IIF(RIGHT(lcTest,1)=CHR(160),.T.,.F.)
>lcTest = ALLTRIM(lcTest,1,CHR(20),CHR(160))
>?IIF(RIGHT(lcTest,1)=CHR(160),.T.,.F.)
>
This was the test I tried yesterday (not sure about hotfixes, VFP9 SP2)
lcText = CHR(160) + "Test"
?ALLTRIM(m.lctext,1,CHR(160))
?ASC(lcText)
If it's not broken, fix it until it is.
My Blog