Hi Hilmar
Thanks for your suggestion.

Unfotunately, I have been given a spec with a particular LIST of characters to eliminate and must stick to this.

There must be somewhere I can get a list of all characters and their Ascii equivalent ?

Regards,
Gerard




>>Hi.
>>I need to export a txt file , but certain characters need to be excluded:
>>e.g. comma(,) Underscore(_) Semicolon(;) etc
>>Most of these I can do a Strtran() and replace
>>But I also need to remove other characters e,g,
>>Currency Sign, Yuan Sign,Copyright symbol,Registerd Sign, 1/4 symbol, 1/4 symbol, 3/4 symbol and about 20 others
>>
>>Is there anywhere I can get a full list of all characters
>>(I had a look at INKEY but it does not give them all.)
>>If I has the Ascii equivalent I could do a test on that.
>>
>>regards,
>>
>>Gerard
>
>It might be easier to include only the characters you want, for instance, uppercase letters, lowercase letters, digits, and a few symbols.
>
>If you are interested in doing this, make a chrtran(), to eliminate them. Then, use the resulting string for a second chrtran(), with the to eliminate everything else from the original string.