Use the Map processor-type Function to manage input fields, that is, to include or exclude fields forwarded by the function. The input fields can be modified using formulas. New fields are created using formulas, based on input fields, or by adding new information.
...
| Operation | Description |
|---|---|
| upperCase(s) | convert input string s to upper case |
| lowerCase(s) | convert input string s to lower case |
| trim(s) | remove leading and trailing spaces from input string s |
| length(s) | gives the length of input string s |
| x + y | concatenate strings x and y |
| slice(x, y) | get the substring of x, starting at index y (y = 0 is first character) |
| slice(x, y, z) | get a slice of z characters from the string x, starting at index y (iy= 0 is first character) |
| split(xx, yy) | allows for strings to be split by a specific substring into an array. Example: split(“foo.bar”, “.”) will generate an array containing [“foo”,“bar”] |
Array operations
| Operation | Function |
|---|---|
| length(x) | gives the length of x |
| slice(x, y) | get the slice of x, starting at index y (y = 0 is first character). |
| slice(x, y, z) | get a slice of z elements from the array x, starting at index y (y = 0 is first character) |
...