• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

Here’s how to use pad() function.

Description:

Pad a string to the specified length with another string added on the left.

Syntax:

Note:

The function pads string s to a new length of l by continuously adding characters of string c to the left side.

Parameter:

 s A string expression c A string expression l A number or an expression whose result is the numeric value

Option:

 @r Pad to the right side of a string, to a new length

Return value:

String

Example:

 A 1 =pad("Soth","Miss",10) The return value is "MissMiSoth". 2 =pad@r("Soth","er",8) The return value is "Sotherer".

Description:

Add members of a sequence to another one until the latter reaches certain length.

Syntax:

Note:

The function adds members of sequence x sequentially and continuously to sequence A until the length of A reaches n. If n is less than A’s length, the function will return A itself.

Parameter:

 A A sequence x A single value or a sequence; with a sequence, add its members sequentially to sequence A n An integer

Option:

 @l Add members before the existing members of sequence A; by default the additions will be placed at its end @m If the length of sequence A is the multiple of n, do not perform the adding action. If the length of A isn’t the multiple of n, add members to A until its length is the multiple of n; the number of additions – which are members of sequence x – need to be added after the existing members can be calculated with the formula – m=n-A.len()%n

Return value:

Sequence

Example:

 A 1 [a,b,c,d,e,f] 2 =A1.pad(["q",2],2) ["a","b","c","d","e", "f"]. 3 =A1.pad("j",9) ["a","b","c","d","e", "f","j","j","j"]. 4 =A1.pad@m("j",3) ["a","b","c","d","e", "f"]. 5 =A1.pad@m("j",5) ["a","b","c","d","e", "f","j","j","j","j"]. 6 =A1.pad@l(["q",2],11) ["q",2, "q",2, "q","a","b","c","d","e", "f"].