Operators

You can use the following logical operators, relational operators, arithmetic operators and string operators in Inxmail Professional. The operators can be used in mailing texts, actions and target groups.

Note: You can only link the same data types with an operator. For example, it is not possible to link the Date and time data type with the Date only data type using operators. An overview of the data types available in Inxmail Professional is provided in the section Creating a new column.

Operator

Description

equal to (=)

Checks for exact equality

unequal to (<>)

Check for inequality

empty column value (IS_EMPTY)

The column value must by empty

not empty column value (NOT_IS_EMPTY)

The column value may not be empty

less than (<)

The column value must be less than the comparison value

greater than (>)

The column value must be greater than the comparison value

less than or equal to (<=)

Less than or equal must match

greater than or equal to (>=)

Greater than or equal must match

like (LIKE)

Comparison which ignores letter case

not like (NOT_LIKE)

Inequality which ignores letter case

starts with (STARTS_WITH)

The column value must begin with the comparison value

does not start with (NOT_STARTS_WITH)

The column value may not begin with the comparison value

ends with (ENDS_WITH)

The column value must end with the comparison value

does not end with (NOT_ENDS_WITH)

The column value may not end with the comparison value

contains (CONTAINS)

The column value must contain the comparison value

does not contain (NOT_CONTAINS)

The comparison value may not be present

+

String concatenator, also adds numbers

-

Subtracts numbers

*

Multiplies numbers

/

Divides numbers

TRUE

Condition is true

FALSE

Condition is not true

OR

Only one condition must be true

If you combine several conditions when defining target groups, you must include the OR operator using the button in the editor.

AND

All conditions must be true

If you combine several conditions when defining target groups, you must include the AND operator using the button in the editor.
  • All women: if Gender = "f"
  • All except women: if Gender <> "f"
  • All with postcode below 79000: if Postcode < 79000
  • All with postcode above 79000: if Postcode > 79000
  • All with postcode of or below 79000: if Postcode <= 79000
  • All born in 1990 or later: if Birthdate >= 1990
  • Searches for values similar to the following: ‘html’, ‘HTML’, ‘HTmL’: if format LIKE "html"
  • All in postcode region 7: if Postcode >= 70000 AND Postcode < 80000
  • All who have an inxmail email address (when searching, a * must never be used as a wild card; use a % instead): if email ENDS_WITH "inxmail.%"
  • All with the title of professor: if Title CONTAINS "Prof."
  • All men interested in sports: if (Gender="m") AND (SportsInterest=TRUE)
  • All women and all male subscribers interested in sports: if (Salutation="Ms") OR (Salutation="Mr" AND Sport="Yes")

  • All whose gender or surname is unknown should be addressed as ‘Dear Subscriber’. All others will be addressed according to their gender.

    Additionally, the ‘firstcap’ parameter (Erstellen von individualisierten Texten (für Zielgruppen)) will be used to ensure that the name always begins with a capital letter.

    Copy 
    [%if (Gender IS_EMPTY) OR (Name IS_EMPTY)]Dear Subscriber,
    [%elseif Gender="m"]Dear Mr [Surname,firstcap],
    [%elseif Gender="f"]Dear Ms [Surname,firstcap],
    [%endif]
  • String the ‘inxmail’ and ‘s’ character strings to inxmails: [%="inxmail" + "s"]

  • String ‘Super-’ character string with value from the ‘First name’ table column:

    [%="Super-" + First name]

    becomes e.g. ‘Super-Mike’

  • String ‘Super-’ character string with value from the ‘First_Name’ (special characters!) table column:

    [%="Super-" + Column("First_name")]

    becomes e.g. ‘Super-Mike’