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 should be used without quotation marks.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us