Foreign Character Conversion - (IE...Cintrón)

[BreffniK]

Product Version 9.2.2.693

We are using a the parameter ?SPUser to display on the report the name of the user who ran the report from our Web app.

When a user with special characters (Cintrón, Juan) runs a report, the value that is returned by SPUser is incorrect (Cintrón, Juan).

Does anyone know of a way to create a formula to convert these special characters correctly?

Thanks

 

[Madawc]

Computers were invented and developed in Britain and the USA, where the language was standardised with a non-phonetic spelling and no accents. (Rough dough-faced ploughmen wandering thoughtfully through Slough etc.) Accented vowels get lumped in with 'special characters' as things just a few people will use.

Worse, most PCs use ASCII, which is standard for the first 128 characters but variable for the other 128. This is because it originated as a code for 7-hole paper tape and it was convenient for US computer developers to work with.

I suggest you do an experimental report, with a formula field containing the code chr(recordnumber) for a selection of 256 records. This will show you the actual characters used, which may differ between fonts.

You could then do a replace, based on the Chr(nn) values.

You could also take a look at Ascii tables , which lists the most popular variants.

Madawc Williams (East Anglia, UK)