The good of the "String manipulation" node is that it can do almost everything we need when dealing with strings, like calculate a string length, compare two strings, change a string into only uppercase or lowercase characters, replace a substring or all occurrences of a character inside a string, capitalize the string words, find the positions of a character or substring occurrence, extract a substring from a string, and so on.
The configuration window of the “String Manipulation” node has an “Expression Editor” in the central bottom part. Here a number of string functions can be combined together to obtain the desired string transformation.
The available string functions are listed above in the “Function List” panel. The “Description” panel on the right explains the task of the selected function.
Functions can also be visualized in smaller groups, by selecting a category in the “Category List” menu over the “Function List” panel.
On the left, in the “Column List” panel, all available input data columns are displayed.
Double-clicking a column or a function automatically inserts it in the “Expression Editor”. String values have to be reported in quotation marks, for example “abc”, when introduced in the “Expression Editor”.
The “Insert Missing As Null” flag enables the production of a null string, instead of an empty data cell, when there are missing values in the input data.
The configuration window finally requires the name of the new or of the existing column, depending on whether the resulting string has to overwrite existing data.