upper
Converts all input strings to uppercase.
Parameters
X (string, list, column, or row)
The input value. This can be a string, a list, or a one-dimensional table region such as a column or row.
Examples
The function can take a string.
ATL in Script | Result |
|---|---|
| ALL WORK AND NO PLAY MAKES JACK A DULL BOY |
It can also take a list, column, or row of strings.
ATL in Script | Result |
|---|---|
[[
beatles = ('John', 'Paul', 'George', 'Ringo')
upper(beatles)
]] | JOHN, PAUL, GEORGE AND RINGO |
Converting all column values to uppercase can help with filtering.
Assume a "Describe the Table" project with this data:
ID | Region | Branch | Sales | |
|---|---|---|---|---|
Row 1 | 1001 | Southeast | Atlanta | 357589.32 |
Row 2 | 1002 | Northeast | Boston | 294293.49 |
Row 3 | 1003 | midwest | Chicago | 403603.17 |
Row 4 | 1006 | Midwest | Indianapolis | 457359.45 |
Row 5 | 1007 | Midwest | Milwaukee | 192238.52 |
Row 6 | 1008 | Northeast | New York | 468745.37 |
The filterRows function is case-sensitive, so [[filterRows(WholeTable, 'Region', eq('Midwest'))]] returns:
ID | Region | Branch | Sales | |
|---|---|---|---|---|
Row 4 | 1006 | Midwest | Indianapolis | 457359.45 |
Row 5 | 1007 | Midwest | Milwaukee | 192238.52 |
To cover all casing variations, convert the Region values to uppercase and use 'MIDWEST' as the constant.
[[filterRows(WholeTable, 'Region', value -> upper(value) == 'MIDWEST')]]
The filtered table is:
ID | Region | Branch | Sales | |
|---|---|---|---|---|
Row 3 | 1003 | midwest | Chicago | 403603.17 |
Row 4 | 1006 | Midwest | Indianapolis | 457359.45 |
Row 5 | 1007 | Midwest | Milwaukee | 192238.52 |
