Hi folks,

I've loaded some text data into PP and am trying to clean it up. I've worked on the major foreign characters but wondered if anyone has had a similar problem before or if there is a comprehensive way to solve this !

Currently I'm running some pilotscript to simply substitute errors for what the foreign character actually is.

eg.

DocText := rsubst(DocText, 'è', 'è','g');
DocText := rsubst(DocText, 'É', 'É','g');
DocText := rsubst(DocText, 'È', 'È','g');
DocText := rsubst(DocText, 'È', 'À','g');
DocText := rsubst(DocText, 'à€', 'È','g');
DocText := rsubst(DocText, 'Ã', 'à','g');
DocText := rsubst(DocText, 'àª', 'â','g');
DocText := rsubst(DocText, 'à§', 'ç','g');

Happy to hear if anyone's experienced the same problem and has a solution or good workaround.

cheers
Nick