Functions extend placeholders and personalization rules. They check, compare, and transform values when a message is sent, for example to compare dates, extract part of a string, or format a number. Functions often require Code View.
The function pages group the functions by purpose. To find a function by its name, use the table below. For the syntax and the function libraries, see Function Basics.
Function Pages
Page | Functions |
|---|
Function Basics | Syntax, function libraries (fn, ecm, ecx), and how functions are evaluated. |
Verify Existing Values | fn:contains, fn:containsIgnoreCase, fn:startsWith, fn:endsWith, fn:indexOf, ecm:regexMatches, ecm:regexMatchesIgnoreCase, ecx:isEmptyCouponList
|
Compare Dates | ecm:equal, ecm:greater, ecm:greaterEqual, ecm:less, ecm:lessEqual, ecm:notEqual, ecm:age, ecm:between, ecx:durationBetween, ecx:isInTimePeriod
|
Verify Quantities | fn:length, ecm:countMapElements
|
Extract String Values | fn:substring, fn:substringAfter, fn:substringBefore, ecm:nvl, ecm:extractDomain, ecm:coalesce
|
Format and Encode Strings | ecm:base64Encode, fn:escapeXml, fn:replace, fn:toLowerCase, fn:toUpperCase, fn:trim, ecx:capitalizeFirstLetter, ecx:capitalizeWords, ecm:concat, ecm:urlEncode, ecm:urlEncodeUsingCharset
|
Extract and Format Numbers | ecx:formatNumber, ecx:forceNumber, ecm:round, ecm:max, ecm:min, ecm:avg, ecm:random, ecx:distribute. Also: mathematical operations.
|
Extract and Format Dates and Times | ecx:formatDate, ecx:fmtDateInTimezone, ecx:formatTimestamp, ecx:getDate, ecx:getTime, ecx:getDateTime, ecm:addInterval, ecm:day, ecm:month, ecm:year, ecm:toDate, ecm:timeZone, ecm:trunc
|
Sort or Filter Data Records | ecx:sort, ecx:filter, ecx:filterDateRange, ecx:filterDateTimeRange, ecx:filterDuplicates, ecx:filterDuplicatesByField, ecx:merge, ecx:related
|
Create Hash Values | ecx:md5hex, ecx:md5base64, ecx:sha256hex
|
Placeholders for eCommerce Data | ecx:productCatalog. Also: placeholders for the eCommerce tables.
|