>I think that the problem I am having with accents is that the accent in question is not a valid accent
>
>If I copy and paste the field it look like this Paris La D‚fense I dont know what character the 2nd letter of Defense is - if anyone can help I can email the info on a spreadsheet - I dont think this charecter is included in the conversion tables you have all so kindly shown me
here you see the chrtran() at work:
x1=[La D‚fense] &&** copied from your message
x2=CHRTRAN(x1,CHR(130),[e])
FOR I = 1 TO LEN(x1)
? SUBSTR(x1,I,1),ASC(SUBSTR(x1,I,1))
ENDFOR
?
* show the translated string:
?x2
Peter Cortiel