UPPER Function

Contents:

On January 27, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

All alphabetical characters in the input value are converted to uppercase in the output value.

Input can be a column reference or a string literal.

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

Column reference example:

upper(MyName)

Output: Returns the values from the MyName column written in UPPER.

String literal example:

upper('Hello, World')

Output: Returns the string: HELLO, WORLD.

Syntax and Arguments

upper(column_string)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of the column or string literal to be applied to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

column_string

Name of the column or string constant to be converted.

Missing string or column values generate missing string results.
String constants must be quoted ('Hello, World').
Multiple columns and wildcards are not supported.

Usage Notes:

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`

Examples

Tip: For additional examples, see Common Tasks.

Example - uppercase, lowercase, propercase functions

Source:

In the following example, you can see a number of input values in the leftmost column. The output columns are blank.

input	uppercase	lowercase	propercase
AbCdEfGh IjKlMnO
go West, young man!
Oh, ($%(&! That HURT!
A11 w0rk and n0 0play makes Jack a dull boy.

Transformation:

To generate uppercase, lowercase, and propercase values in the output columns, use the following transforms:

Transformation Name	`Edit column with formula`
Parameter: Columns	`uppercase`
Parameter: Formula	`UPPER(input)`

Transformation Name	`Edit column with formula`
Parameter: Columns	`lowercase`
Parameter: Formula	`LOWER(input)`

Transformation Name	`Edit column with formula`
Parameter: Columns	`propercase`
Parameter: Formula	`PROPER(input)`

Results:

input	uppercase	lowercase	propercase
AbCdEfGh IjKlMnO	ABCDEFGH IJKLMNO	abcdefgh ijklmno	Abcdefgh Ijklmno
go West, young man!	GO WEST, YOUNG MAN!	go west, young man!	Go West, Young Man!
Oh, ($%(&! That HURT!	OH, ($%(&! THAT HURT!	oh, ($%(&! that hurt!	Oh, ($%(&! That Hurt!
A11 w0rk and n0 0play makes Jack a dull boy.	A11 W0RK AND N0 0PLAY MAKES JACK A DULL BOY.	a11 w0rk and n0 0play makes jack a dull boy.	A11 W0rk And N0 0play Makes Jack A Dull Boy.

See Also:

Send Feedback

Page tree