the function $$Upper has been used to convert the string expressions to upper case, but there were no functions available for other conversions like Lower case, Title Case, etc. To overcome the difficulty of converting the string to Lower case, Title case, etc., a new function $$CaseConvert has been introduced, to convert the case of the given expression to the specified case format. This function will return a string expression in the converted format This function is very useful when one needs to follow the case rules to display the Name of the company, Name of the bank, etc.
Syntax
$$CaseConvert : CaseKeyword :Expression
Where,
CaseKeyword can be All Capital, Upper Case, All Lower, Lower Case, Small Case, First Upper Case, Title Case, TitleCaseExact, Normal, Proper Case, etc.
* All Capital/UpperCase converts the input expression to upper case.
* All Lower/LowerCase/SmallCase converts the input expression to lower case.
* First Upper Case converts the first letter of the first word in a sentence to upper case. Other characters will remain as they are.
* TitleCase converts the input expression to Title case, i.e., the principal words should start with capital letters.
It will not convert the prepositions, articles or conjunctions, unless one is the first word.
It will ignore a subset of words from capitalization like the, an, and, at, by, to, in, of, for, on, cm, cms, mm, inch, inches, ft, x, dt, eis, dss, with, etc. For this subset of words, the original strings’ cases will be preserved.
* TitleCaseExact converts the input expression to Title case, i.e., the principal words will start with capital letters.
It will not convert the prepositions, articles or conjunctions, unless one is the first word.
It will ignore a subset of words from capitalization like the, an, and, at, by, to, in, of, for, on, cm, cms, mm, inch, inches, ft, x, dt, eis, dss, with, etc. This subset of words will be converted to small case.
* Proper Case converts the input expression to Title case, i.e., all the words in a sentence should start with capital letters.
* Normal preserves the input expression as it is.
Syntax
$$CaseConvert : CaseKeyword :Expression
Where,
CaseKeyword can be All Capital, Upper Case, All Lower, Lower Case, Small Case, First Upper Case, Title Case, TitleCaseExact, Normal, Proper Case, etc.
* All Capital/UpperCase converts the input expression to upper case.
* All Lower/LowerCase/SmallCase converts the input expression to lower case.
* First Upper Case converts the first letter of the first word in a sentence to upper case. Other characters will remain as they are.
* TitleCase converts the input expression to Title case, i.e., the principal words should start with capital letters.
It will not convert the prepositions, articles or conjunctions, unless one is the first word.
It will ignore a subset of words from capitalization like the, an, and, at, by, to, in, of, for, on, cm, cms, mm, inch, inches, ft, x, dt, eis, dss, with, etc. For this subset of words, the original strings’ cases will be preserved.
* TitleCaseExact converts the input expression to Title case, i.e., the principal words will start with capital letters.
It will not convert the prepositions, articles or conjunctions, unless one is the first word.
It will ignore a subset of words from capitalization like the, an, and, at, by, to, in, of, for, on, cm, cms, mm, inch, inches, ft, x, dt, eis, dss, with, etc. This subset of words will be converted to small case.
* Proper Case converts the input expression to Title case, i.e., all the words in a sentence should start with capital letters.
* Normal preserves the input expression as it is.