JungleDocs 365 | Text formatting

SubString(text, startPosition), SubString(text; startPosition; length) – Retrieves a substring from text. The substring starts at a specified character position and has a specified length. First character is at 0 position.
Example: SubString("abcde"; 1) Result: bcde
Example: SubString("abcde"; 2; 1) Result: c
Example: SubString(FirstName; 1; 1) Result: M

Lower(text) – Converts text to lowercase.
Example: Lower("The Table") Result: the table

Upper(text) – Converts text to uppercase.
Example: Upper("The Table") Result: THE TABLE

PadLeft(text; totalLength), PadLeft(text; totalLength; symbol) – Right-aligns the characters in text, padding with spaces or symbol on the left for a specified total length.
Example: PadLeft("123"; 5; "0") Result: 00123

PadRight(text; length), PadRight(text; totalLength; symbol) – Left-aligns the characters in text, padding with spaces or symbol on the right for a specified total length.
Example: PadRight("123"; 5; "0") Result: 12300

PlainText(text) - Converts Rich text to Plain text,

where text - any text value or text field.

Note: Text value in formulas should be surrounded by quotation marks, Column name - without quotation marks.

Still need help? Contact Us Contact Us