JAVA_STRING
Description
JAVA_STRING
is a row function that returns the unescaped version of a Java unicode character escape sequence as a TEXT
value. This is useful when you want to specify unicode characters in an expression. For example, you can use JAVA_STRING
to specify the unicode value representing a control character.Syntax
JAVA_STRING
(unicode_escape_sequence
)Return Value
Returns the unescaped version of the specified unicode character, one value per row of type
TEXT
.Input Parameters
- unicode_escape_sequence
- Required. ATEXTvalue containing a unicode character expressed as a Java unicode escape sequence. Unicode escape sequences consist ofa backslash '\' (ASCII character 92, hex 0x5c), a 'u' (ASCII 117, hex 0x75), optionally one or more additional 'u' characters, and four hexadecimal digits (the characters '0' through '9' or 'a' through 'f' or 'A' through 'F'). Such sequences represent the UTF-16 encoding of a Unicode character. For example, the letter 'a' is equivalent to '\u0061'.
Examples
Evaluates whether the
currency
field is equal to the yen symbol.CASE WHEN [currency] == JAVA_STRING("\u00a5") THEN "yes" ELSE "no" END