Links

STRIP_MARGIN

For each line remove prefix of control or whitespace characters followed by the given margin char

Syntax

STRIP_MARGIN(marginChar, input)

Arguments

Name
Type
Description
Default Value
marginChar
char
input
string

Returns

string

Examples

marginChar
input
Output
"|"
'Hello
\| World' | World` |

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 marginChar, input,
STRIP_MARGIN("|", input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET marginChar = "|",
input = 'Hello
World'
WHERE time_filter()
LIMIT 1;

Query result

marginChar
input
Output
"|"
'Hello
\| World' | World` |