Links

LPAD

Uses a given padstring to left pad a string to a certain size.

Syntax

LPAD(STRING, SIZE, PADSTRING)

Arguments

STRING

Type: string
The string to be padded.

SIZE

Type: bigint
A non-negative integer specifying the length of the result string.

PADSTRING

Type: string
The string to use for padding. This must be non-empty.

Returns

Type: string
STRING left padded to SIZE with PADSTRING.
If SIZE is less than the length of STRING, the result is truncated to SIZE characters.

Examples

STRING
SIZE
PADSTRING
Output
Call me Ishmael. Some years ago
7
Call me
drizzly November
16
.
drizzly November
right
1
r
what
9
?!
?!?!?what
null
9
''
null
hi
5
five
fivhi
hi
10
five
fivefivehi

Transformation job example

SQL

CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT
customer_firstname,
LPAD(customer_firstname, 10, 'x') AS padded_firstname
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE time_filter()
LIMIT 3;

Query result

customer_firstname
padded_firstname
Donna
xxxxxDonna
Lawrence
xxLawrence
Julie
xxxxxJulie
Last modified 5mo ago