PAD_RIGHT

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

Syntax 

PAD_RIGHT(input, target_length, pad_value)

Usage examples 

Example 1

Input

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

Formula

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

Output

"inputaaaaa"

Example 2

Input

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

Formula

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

Output

"inputabcab"
Was this helpful?