Change the Case of a Value

April 14, 2011 User Reference
Thumbnail image for Change the Case of a Value

ToUpper. This will place the uppercase value of the data into the document: <<List(parties,ToUpper(firstname) ToUpper(surname),!, , and )>> “Fred Basset” becomes “FRED BASSET” ToLower. Converts the value to lowercase: <<ToLower(NatureOfAccount)>> “DEBTOR” becomes “debtor” ToSentence. Converts the value to lower case except for the first character which is converted to upper case: <<ToSentence(ProductDescription)>> “WIDE GAUGE RAILWAY […]

Read the full article →