Table of Contents

, ,

PAD_LEFT

Description

Pads the given string on the left with the specified character

Syntax

PAD_LEFT (text, character, length)

Cannot be used in the condition of a FIND action.

Parameters

Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string

Returns

Text: the string padded on the left with the character up to the given length.

Example

PAD_LEFT ('John', '0', 6) 

returns 00John

PAD_RIGHT, TRIM, LENGTH