Stringfunctions+ | Formula STRPAD

Description

This formula extends a string to a certain length using another string.

Formula(s)

PHP
{=STRPAD("Input";Length;"String";Type)}

Result

  • String

Parameters

Parameter
Content
Format
Default value
Explanation

Input

Source string

String

 

 

Length

Desired length of the result string

Integer

 

 

String

String to be used for shortening the source string

String

" "

 

Type

Shortening option (right, left, both)

Integer

 

Possible values:

  • PADTYPERIGHT

  • PADTYPELEFT

  • PADTYPEBOTH