Segmentation operators

When setting conditions on attributes in the segment canvas, you have the option of using the following operators.

Review CSV file requirements to learn about valid and invalid CSV formats.

String and Text data type

  • Matches
  • Matches (Attribute)
  • Matches (CSV file)
  • Does not match
  • Does not match (Attribute)
  • Does not match (CSV file)
  • Matches regex (regular expression)
  • Does not match regex (regular expression)
  • Contains
  • Does not contain
  • Begins with
  • Does not begin with
  • Ends with
  • Does not end with
  • Is empty
  • Is not empty

The following operators are case insensitive: Matches, Does not match, Matches regex, Does not match regex, Contains, Does not contain.

Japanese characters

Note: To enable operators for Japanese characters, contact Oracle Support.

When the operators below are selected, Oracle Unity will ensure that the query treats different variants as equivalent, including:

  • Katakana and hiragana

  • Full- and half-width characters

  • Small and large kana symbols

These options will also normalize large and small Roman letters (for example J=j). However, they will not treat old and new kanji as the same.

  • Matches (Japanese)

  • Does not match (Japanese)

  • Contains (Japanese)

  • Does not contain (Japanese)

  • Begins with (Japanese)

  • Does not begin with (Japanese)

  • Ends with (Japanese)

  • Does not end with (Japanese)

Number data types (for example, integer or decimal)

  • Matches
  • Matches (Attribute)
  • Matches (CSV file)
  • Does not match
  • Does not match (Attribute)
  • Does not match (CSV file)
  • Between
  • Not between
  • Greater than
  • Greater than or equal to
  • Less than
  • Less than or equal to
  • Is empty
  • Is not empty

Date and timestamp data types

Notes:
  •  When using attributes that have the data type date or timestamp and operators that include months (for example, in the next month or in the past two months), the number of days will be calculated by multiplying the number of months by 30. For example, in the next six months will be calculated as (6 x 30 = 180 days).
  • The operators Today and Not today are based on the timezone Coordinated Universal Time (UTC).

The date data type operators are categorized By calendar date and By #days/weeks/months. The timestamp data type operators are categorized By calendar date and By #days/weeks/months/hours.

When selecting By calendar date, you will need to select either one or two dates depending on the operator. If you select Is empty or Is not empty, you do not select dates since the operator only detects if a value exists for the attribute.

When selecting By #days/weeks/months or By #days/weeks/months/hours, you need to select an additional input field that determines if you are calculating by days, weeks, months, or hours.

By calendar date

  • On
  • Not on
  • Between
  • After
  • On or After
  • Before
  • On or before
  • Not on or before
  • Not on or after
  • Not between
  • Is empty
  • Is not empty

By #days/weeks/months/hours

  • In the past
  • In the next
  • Before the past
  • After the next
  • Not before the past
  • Not after the next
  • Not in the past
  • Not in the next
  • Not between
  • Today
  • Not today

Boolean data type

Attributes with the boolean data type have two input fields that need to be completed.

First input field

  • Matches
  • Does not match

Second input field

  • True
  • False

CSV file requirements

  • Each row can contain only one value.

  • If the value contains a comma, space, single quote, or any other special character, it must be enclosed in double quotes.

  • If the value contains a double quote, the double quote must be escaped with the backslash character (\).

  • The value cannot contain a new line.

Invalid values

The following values do not follow all the requirements above.

  • last, line

  • "last

  • value"

  • "my"value"

  • my 'new' value

  • John's data

  • "last""line""

Valid values

The invalid values above are now valid after addressing their errors.

  • "last, line"

  • "\"last"

  • "value\""

  • “my \” value”

  • "my 'new' value "

  • "John's data"

  • "last\"\"line"

Learn more

Creating segments

Managing segments

segment, segmentation, create segment, how to create a segment, operators, data type, string, integer, number, boolean, date, timestamp, null