Striim 3.9.7 documentation

String functions

function

description

notes

ARLEN(String)

returns the number of fields in the specified array

see Handling variable-length events with CQs for an example

BEFORE(String)

returns the values in the WAEvent before array of the specified stream as a java.util.HashMap, with column names as the keys

see Using the DATA() and BEFORE() functions

DATA[Integer]

returns the value from field number Integer in a WAEvent data array

see Parsing the fields of WAEvent for CDC readers

DATA(String)

returns the values in the WAEvent data array of the specified stream as a java.util.HashMap, with column names as the keys

see Parsing the fields of WAEvent for CDC readers , Using the DATA() function, and Using the DATA() and BEFORE() functions

IP_CITY(String)

get the city for an IP address

uses MaxMind GeoIP

IP_COUNTRY(String)

get the country for an IP address

uses MaxMind GeoIP

IP_LAT(String)

get the latitude for an IP address

uses MaxMind GeoIP

IP_LON(String)

get the longitude for an IP address

uses MaxMind GeoIP

IS_PRESENT()

see Parsing the fields of WAEvent for CDC readers

match(String s, String regex)

match(String s, String regex, Integer groupNumber)

match the string using the specified regex expression. You can optionally specify the capture group number (the default is 0).

supports only single return value )see Using regular expressions (regex))

maxOccurs(String)

value that had the maximum occurrences in the String

see MultiLogApp for examples

META()

extracts a value from a WAEvent METADATA map

see Using the META() function

SLEFT(Object, Integer)

returns only the characters to the left of position Integer from the object

SRIGHT(Object, Integer)

returns only the characters to the right of position Integer from the object

for example, SRIGHT(orderAmount,1) would remove a dollar, Euro, or other currency sign from the beginning of a string

TO_BOOLEAN(Object)

convert a string to a Boolean

TO_STRING(Object)

convert any object to a string