>>>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.)
>
May be difference in hotfixes? I'll try to get them
lcText = "Test"+CHR(160)
?ASC(RIGHT(lcText,1))
?ALLTRIM(m.lctext,1,CHR(20),CHR(160))
?ASC(RIGHT(lcText,1))
If it's not broken, fix it until it is.
My Blog