Skill level: Intermediate

Time required: 3 minutes

• Skills for appropriate usage of formulas for strings defined as input

Quickwork Journey Builder supports a variety of string formulas. Using these formulas, one can count characters, compare data, perform string validations, and so on.

Note: Most formulas will return an error and stop the journey execution if operated on blank input fields.

In the examples below, we will look at some of the methods that can be used to manipulate a string of text, which in this case the input string is John Doe.

Conditionals

This section will cover formulas that allow you to apply conditions (if-else) to your strings.

This function checks the input string and returns true if it is an empty string or if it is null:

This function returns the number of characters within an input string, including the white spaces:

This function converts all characters from the input string into lowercase:

4) trimLeft

This function (left strip) removes the white spaces at the beginning of the input string:

4) trimRight

This function (right strip) removes the white spaces at the beginning of the input string:

This function converts all characters from the input string into uppercase: