There are times when we are required to do some manipulations on fields that are stored as strings. Typical calculations that we may do on strings are as follows:
In the following recipe, let's do some string manipulations to create new calculated fields.
For the following recipe, we will use the Customer Name field from the Orders sheet from
Sample - Superstore.xlsx data and we will continue working ...