ToUpper - XpressDox

Regardless of the case of the value entered into the interview or imported from a database, that value can be converted into UPPER CASE.

Command structure:

«ToUpper(FullName)»
“Fred Basset” becomes “FRED BASSET”

Additional parameters on the ToUpper command:

Double clicking on the “ToUpper” command from the Command Assistant will provide the basic helper. However, if you single click on the command (or any command) you can access other versions of the helper and in the case of ToUpper, you can choose to “Convert a data element value, specifying a substring”.

ToUpper can begin converting the string at any character supplied at the Starting Character Number, 1 being the first character. And similarly, should you wish to convert only a part of the string, then insert a number into the 3rd block. A 0 means that the entire string will be converted. These are both optional, and a 1 and 0 mean that the entire string will be converted into UPPER CASE.

Combining ToUpper with other functions:

«Comment(Example 1: Convert today's date into Upper Case)»
«ToUpper(Today('d MMMM yyyy'))»

«Comment(Example 2: ToUpper used with List command)»
«List(Plaintiff,ToUpper(Name),!, , AND )»

Related articles:

Change the case of a value