String Manipulation

The String Manipulation node is used to create new or updating existing string fields. It works row-by-row; this means you can reference values in a given row but you cannot reference values in other rows. For that functionality, see the Lag Column or Column Expressions nodes.

The String Manipulation node's configuration menu allows you to use values from existing columns and flow variables. These are accessible through the Column and Flow Variables lists on the left of the menu. In the center is a list of available functions. Formulas are entered in the Expressions pane below. Finally, you may create a new field (Append Column) or update an existing field (Replace Column).

Common string manipulations include:
- Replacing a value in a string with some other character. For example, removing " characters from a string (replace)
- Stripping whitespace from a string (strip, stripEnd, stripStart)
- Extracting a sub string from a particular string value (substr)
- Combining multiple string values (either from existing fields or manually entered values) into a single string (join)

Note: Functions are case sensitive. lowerCase is good, but lowercase will return an error.