PAD_LEFT

Prepends specified text to the beginning of the input text until it reaches the defined target length. The target length cannot exceed 65536.

Syntax 

PAD_LEFT(input, target_length, pad_value)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"my_text": "input"
4
}
5
}

Formula

PAD_LEFT(my_action.my_text, 10, "a")

Output

"aaaaainput"

Example 2

Input

1
{
2
"my_action": {
3
"my_text": "input"
4
}
5
}

Formula

PAD_LEFT(my_action.my_text, 10, "abc")

Output

"abcabinput"
Was this helpful?