Original data:
IBM DATA CORP
1800 BOUL RENÉ-LÉVESQUE W TOWER A
MONTRÉAL, QC
H2X 3Z5
With Casing set to Proper, Punctuation to Remove and expand abbreviations the result would be:
IBM Data Corporation
1800 boulevard René-Lévesque West Tower A
Montréal, QC
H2X 3Z5
With Casing set to Proper, Punctuation to Add and Remove accents the result would be:
IBM Data Corp.
1800 boul Rene-Levesque W Tower A
Montreal, QC
H2X 3Z5
 
My table contains records that are either English or French. Is there a way to accent the French records alone?
Answer
Yes. If your table contains a language field that identifies a record as French or English. Accents will only be applied to records where the language field starts with "F". Records where the language field starts with "E" or are blank/null will only have the case conversion performed.