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.

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.

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