JungleDocs | Text formatting formulas

In JungleDocs you can use formulas to format your texts. In this tutorial you will learn how to do this.

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

LimitText(text; length) - crop text to approximate characters length without word cut-off. Adds ellipsis (...) at the end of result text.
Example: LimitText(Notes; 25) - where "Notes" - multiple line text column name; "25" - approximate length. Result: Testing JD character...

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