Text formatting
Applies to JungleDocs for Office 365.
For a similar tutorial for JungleDocs for SharePoint 2010-2019, click here.
You can use the following formulas in
Formulas
SubString(text, startPosition)
, SubString(text; startPosition; length)
– retrieves a substring from
0
Example: SubString("abcde"; 1)
Result: bcde
Example: SubString("abcde"; 2; 1)
Result: c
Example: SubString(FirstName; 1; 1)
Result: M
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
Example: PadLeft("123"; 5; "0")
Result: 00123
PadRight(text; length)
, PadRight(text; totalLength; symbol)
– left-aligns the characters in
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 and the column name should be used without them.