After reading w3school documents, you can see that XSLT provides two system functions to convert string case formats: upper-case () and lower-case (). However, these two functions are for analyticdb 1.0 and later versions. Microsoft uses XSLT, so when youCodeWhen these two functions are used, the system prompts that they are invalid. Here is an alternative solution, which can be solved by using the translate () function.
< XSL: Variable Name = "Smallcase" Select = "'Abcdefghijklmnopqrstuvwxy '" /> < XSL: Variable Name = "Uppercase" Select = "'Abcdefghijklmnopqrstuvwxy '" /> < XSL: Template Match = "/" > < XSL: value- Select = "Translate (Doc, $ smallcase, $ uppercase )" /> </ XSL: Template >
two variables are defined in advance, which are used to store the upper and lower case formats of 26 English letters. Then, the strings to be converted in the translate () function. In the above example, the string is converted to uppercase, and the position of the $ smallcase and $ uppercase variables is reversed to lowercase.