LPAD
Uses a given padstring to left pad a string to a certain size.
Syntax
LPAD(STRING, SIZE, PADSTRING)
Arguments
STRING
STRING
Type: string
The string to be padded.
SIZE
SIZE
Type: bigint
A non-negative integer specifying the length of the result string.
PADSTRING
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 $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 3;
Query result
customer_firstname
padded_firstname
Donna
xxxxxDonna
Lawrence
xxLawrence
Julie
xxxxxJulie
Last updated