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.

Syntax

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.

Examples:

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...

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 is any text value or text field.