Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

...

OperationDescription
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

OperationFunction
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)

...