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. Formulas are whitelisted Ruby methods, and therefore not all Ruby methods are supported. Syntax and functionality for these formulas are generally unchanged. Take note that most formulas will return an error and stop the job if it tries to operate on nulls (expressed as nil in Ruby), except for blank.

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: