K3 Documents

Parse a String / Extract a Substring

Updated Jan 26, 2021

Copy and Paste the following formula using your data where necessary.

Description:

 Take the 11th through the 17th character of "Product (REF)"

{Product (REF)}.substring(10,17)

Description:

Take the suffix of a string beginning from the last instance of a character.

{String Field}.substring({String Field}.lastIndexOf("Character Reference") + 1, {String Field}.length())
Previous Article Padding a String with Characters
Next Article Hashing Values