Text formatting formulas

Applies to JungleDocs for SharePoint 2010-2019.
For a similar tutorial for JungleDocs for Office 365, click here.

This tutorial describes the syntax and usage of JungleDocs formulas that you can apply to format your texts automatically.


SubString(text; startPosition)

SubString(text; startPosition; length)

Retrieves a substring from the text. The substring starts at a specified character position and has a specified length. The first character is at 0 position.


SubString("abcde"; 1) Result: bcde

SubString("abcde"; 2; 1) Result: c

SubString(FirstName; 0; 1) Result: D, where FirstName resolves to the string David.

LimitText(text; length)

Crops text to approximate characters length without word cut-off. Adds ellipsis (...) at the end of result text.

Example: LimitText(Notes; 25) (Notes - a multiple-line text column name, 25 - approximate length). Result: Testing JD character...


Converts text to lowercase.

Example: Lower("The Table") Result: the table


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


Converts Rich text to plain text, where text is any text value or text field. 


Text values 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