Character case conversion: upper/lower

Syntax

{ upper | lower }¹ ( op )

Input parameters

op	the operand

Examples of valid syntaxes

upper("Hello")
lower(ds_1)

Semantics for scalar operations

Converts the character case of a string in upper or lower case. For example, upper("Hello") gives "HELLO".

Input parameters type

op

dataset { measure<string> _+ }
| component<string>
| string

Result type

result

dataset { measure<string> _+ }
| component<string>
| string

Additional Constraints

None.

Behavior

The operator has the behaviour of the “Operators applicable on one Scalar Value or Data Set or Data Set Component” (see the section “Typical behaviours of the ML Operators”).

Examples

Given the operand dataset DS_1:

Input DS_1 (see structure)

Id_1	Id_2	Me_1
1	A	hello
2	B	hi

Example 1

DS_r := upper(DS_1);

results in (see structure):

DS_r
Id_1	Id_2	Me_1
1	A	HELLO
2	B	HI

Example 2

DS_r := DS_1[calc Me_2:= upper(Me_1)];

results in (see structure):

DS_r
Id_1	Id_2	Me_1	Me_2
1	A	hello	HELLO
2	B	hi	HI