LISTSERV Maestro 9.0-10 Help

Table Of Contents

Calculation Formulas

Back to Calculation Formulas Overview


Formula Functions

The following pages describe the functions that are available for use in LISTSERV Maestro formulas.

Number Functions
Abs Converts a number into its absolute (non-negative) value.
IsNum Checks if the given argument can be converted into a number.
Max Finds the largest of several numbers.
Min Finds the smallest of several numbers.
Pow Raises a number to a specified power.
Random Generates a random number.
ToNum Converts any non-number data type into a number.
Text Functions
Contains Checks if one text contains another.
EndsWith Checks if a text ends with a certain text suffix.
HTMLEncode Encodes all HTML-unsafe characters in a text.
IndexOf Finds the first (or next) occurrence of one text in another.
LastIndexOf Finds the last (or previous) occurrence of one text in another.
Length Determines the length of a text.
Matches Determines if a text matches a certain "regular expression".
ReplaceText Replaces all occurrences of a certain sub-string in a text with a new string.
StartsWith Checks if a text starts with a certain text prefix.
Substring Extracts a specified substring from a text.
ToLower Converts a text into all lowercase.
ToUpper Converts a text into all UPPERCASE.
ToString Converts the argument into a text or set of texts.
Trim Trims leading and trailing whitespace from a text.
URLEncode Encodes all URL-unsafe characters in the text.
Boolean Functions
If Evaluates a condition and determines one of two possible values as a result.
Set Functions
Count Counts all elements in a set.
In Determines if a set contains a certain element.
SetOf Builds a set out of a list of elements.
SetToString Converts a set into a string by listing all elements in the set.
SetToStringWithMaxLen Converts a set into a string (with a maximum length) by listing all elements in the set.
Date / Time Functions
Age Determines the age (in years), based on a birthday date and a current date.
CalendarAdd Performs calendar arithmetic on a milliseconds timestamp.
CurrentMillis Determines the current date/time, in milliseconds.
IsDate Checks if a textual date/time representation is valid.
LastMidnightMillis Determines the date/time of the most recent midnight, in milliseconds.
NextAnniversary Determines the next anniversary of a given historic date/time after a given reference date/time, in milliseconds.
SubscribeTimeMillis Determines the subscription date/time of a subscriber, in milliseconds.
ThisMonthStartMillis Determines the start of the current month, in milliseconds.
ThisWeekStartMillis Determines the start of the current week, in milliseconds.
ToDateText Converts a milliseconds time value into a textual date/time representation.
ToMillis Converts a textual date/time representation into a milliseconds time value.
ToDate This function has been deprecated. Use ToDateText instead.
Other Functions
IsSupplied Checks if a certain merge field has a value or not.
SecondaryValue Retrieves the secondary values for a single/multiple select profile field.

© 2002-2020 L-Soft Sweden AB. All rights reserved.