padLeft

Description

Adds characters to the beginning of a string until it reaches the desired length. If the string is longer than the target length, it is truncated from the end.

Syntax

Like many functions in DataPrime, padLeft supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

padLeft(value: string, charCount: number, fillWith: string): string

(value: string).padLeft(charCount: number, fillWith: string): string

Arguments

Example

Ensure all strings are the same length

Consider the following documents:

{ "name": "Chris" }
{ "name": "David" }
{ "name": "John" }

Use padLeft to make all names 10 characters long:

Example query

create name_padded from padLeft(name, 10, 'X')

create name_padded from name.padLeft(10, 'X')

Example output

{
    "name": "Chris",
    "name_padded": "XXXXXChris"
}
{
    "name": "David",
    "name_padded": "XXXXXDavid"
}
{
    "name": "John",
    "name_padded": "XXXXXXJohn"
}