String functions

String functions operate on data items with a string value-type like left or strcount

  • quote - add single quotes around a string value
  • unquote - remove single quotes from a string value
  • dquote - add double quotes around a string value
  • undquote - remove double quotes from a string value
  • uppercase - convert a string value to uppercases
  • lowercase - convert a string value to lowercases
  • replace - replace a substring within a string value
  • replace_value - replace a string value with a string value that fully matches
  • repeat - repeat a string value a specific number of times
  • trim - remove spaces before and after non-space characters in a string value
  • ltrim (left trim) - remove spaces from the left until non-space characters in a string value
  • rtrim (right trim) - remove spaces from the right until non-space characters in a string value
  • aslist - aggregates string values to a new string data item with a configurable character separator
  • asexprlist - aggregates string values to a new string data item, semicolon delimited and single quoted
  • asitemlist - aggregates string values to a new string data item, comma delimited
  • asdatastring - aggregates string values to a new string parameter, comma delimited and single quoted
  • [[split_piped_string]] - to be added
  • [[split_multi_linstring]] - to be added