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

STRINGSIZEPADSTRINGOutput

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_firstnamepadded_firstname

Donna

xxxxxDonna

Lawrence

xxLawrence

Julie

xxxxxJulie

Last updated