Convert Letter Casing

Scrubs' Casing function transforms your data based on capitalization settings that you choose. Data can be in English, French or mixed.

Data Elements That Can Be Cased:

  • Company names
  • An individual's name - honorific, first, middle and last name, suffix professional title
  • Street addresses
  • City
  • Province or State
  • General - fields not of the above types that require basic upper and lower casing

Settings

Casing/Capitalization

  • Proper - The first letter of the sentence is capitalized, with the rest being lower case.
  • Upper – All letters are capitalized.
  • Preserve – Punctuate or abbreviate data elements while keeping the current casing.

Punctuation

  • Add – Inserts periods for abbreviations when missing.
  • Remove – Deletes the period from abbreviations
  • Preserve - Maintains existing punctuation.

Abbreviations

Full – Changes abbreviated elements to the correct form e.g. St. to Street.

French Accents

  • Add – Converts English words to accented French equivalent.
  • Remove – Converts all accented words into their English representation.
 
Convert upper lower letters
 
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
Questions about case conversion
 
 

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.

 

Did we answer your question? If not contact us and you will get an answer promptly.