蜜豆视频

String Functions string

Learn how to use String functions in the personalization editor.

Camel Case camelCase

The camelCase function capitalizes the first letter of each word of a string.

Syntax

{%= camelCase(string)%}

Example

The following function will capitalize the first letter of word in the profile鈥檚 street address.

{%= camelCase(profile.homeAddress.street) %}

Char code at char-code-at

The charCodeAt function returns ASCII value of a character, like the charCodeAt function in JavaScript. It takes a string and an integer (defining the position of character) as input arguments and returns its corresponding ASCII value.

Syntax

{%= charCodeAt(string,int) %}: int

Example

The following function returns the ASCII value of o i.e 111.

{%= charCodeAt("some", 1)%}

Concat concate

The concat function combines two strings into one.

Syntax

{%= concat(string,string) %}

Example

The following function will combine profile city and country in a single string.

{%= concat(profile.homeAddress.city,profile.homeAddress.country) %}

Contains contains

The contains function is used to determine if a string contains a specified substring.

Syntax

{%= contains(STRING_1, STRING_2, CASE_SENSITIVE) %}

Examples

Does not contain doesNotContain

The doesNotContain function is used to determine if a string does not contain a specified substring.

Syntax

{%= doesNotContain(STRING_1, STRING_2, CASE_SENSITIVE)%}

Example

The following query determines, with case sensitivity, if the person鈥檚 email address does not contain the string 鈥�2010@gm鈥�.

{%= doesNotContain(profile.person.emailAddress,"2010@gm")%}

Does not end with doesNotEndWith

The doesNotEndWith function is used to determine if a string does not end with a specified substring.

Syntax

{%= doesNotEndWith(STRING_1, STRING_2, CASE_SENSITIVE)%}

Example

The following query determines, with case sensitivity, if the person鈥檚 email address does not end with 鈥�.com鈥�.

doesNotEndWith(person.emailAddress,".com")

Does not start with doesNotStartWith

The doesNotStartWith function is used to determine if a string does not start with a specified substring.

Syntax

{%= doesNotStartWith(STRING_1, STRING_2, CASE_SENSITIVE)%}

Example

The following query determines, with case sensitivity, if the person鈥檚 name does not start with 鈥淛oe鈥�.

{%= doesNotStartWith(person.name,"Joe")%}

Encode 64 encode64

The encode64 function is used to encode a string to preserve Personal Information (PI) if to be included for example in a URL.

Syntax

{%= encode64(string) %}

Ends with endsWith

The endsWith function is used to determine if a string ends with a specified substring.

Syntax

{%= endsWith(STRING_1, STRING_2, CASE_SENSITIVE) %}

Example

The following query determines, with case sensitivity, if the person鈥檚 email address ends with 鈥�.com鈥�.

{%= endsWith(person.emailAddress,".com") %}

Equals equals

The equals function is used to determine if a string is equal to the specified string, with case sensitivity.

Syntax

{%= equals(STRING_1, STRING_2) %}

Example

The following query determines, with case sensitivity, if the person鈥檚 name is 鈥淛ohn鈥�.

{%=equals(profile.person.name,"John") %}

Equals Ignore Case equalsIgnoreCase

The equalsIgnoreCase function is used to determine if a string is equal to the specified string, without case sensitivity.

Syntax

{%= equalsIgnoreCase(STRING_1, STRING_2) %}

Example

The following query determines, without case sensitivity, if the person鈥檚 name is 鈥淛ohn鈥�.

{%= equalsIgnoreCase(profile.person.name,"John") %}

Extract Email Domain extractEmailDomain

The extractEmailDomain function is used to extract the domain of an email address.

Syntax

{%= extractEmailDomain(string) %}

Example

The following query extracts the email domain of the personal email address.

{%= extractEmailDomain(profile.personalEmail.address) %}

Format currency format-currency

The formatCurrency function is used to convert any number into its corresponding language-sensitive currency representation depending on the locale passed as a string in the second argument.

Syntax

{%= formatCurrency(number/double,string) %}: string

Example

This query returns 拢56.00

{%= formatCurrency(56L,"en_GB") %}

Get url host get-url-host

The getUrlHost function is used to retrieve the hostname of a URL.

Syntax

{%= getUrlHost(string) %}: string

Example

{%= getUrlHost("https://www.myurl.com/contact") %}

Returns 鈥渨ww.myurl.com鈥�

Get url path get-url-path

The getUrlPath function is used to retrieve the path after the domain name of a URL.

Syntax

{%= getUrlPath(string) %}: string

Example

{%= getUrlPath("https://www.myurl.com/contact.html") %}

Returns 鈥�/contact.html鈥�

Get url protocol get-url-protocol

The getUrlProtocol function is used to retrieve the protocol of a URL.

Syntax

{%= getUrlProtocol(string) %}: string

Example

{%= getUrlProtocol("https://www.myurl.com/contact.html") %}

Returns 鈥渉ttp鈥�

Index Of index-of

The indexOf function is used to return the position (in the first argument) of the first occurrence of the second parameter. Returns -1 if there is no match.

Syntax

{%= indexOf(STRING_1, STRING_2) %}: integer

Example

{%= indexOf("hello world","world" ) %}

Returns 6.

Is empty isEmpty

The isEmpty function is used to determine if a string is empty.

Syntax

{%= isEmpty(string) %}

Example

The following function returns 鈥榯rue鈥� if the profile鈥檚 mobile phone number is empty. Else, it will return 鈥榝alse鈥�.

{%= isEmpty(profile.mobilePhone.number) %}

Is Not Empty is-not-empty

The isNotEmpty function is used to determine if a string is not empty.

Syntax

{= isNotEmpty(string) %}: boolean

Example

The following function returns 鈥榯rue鈥� if the profile鈥檚 mobile phone number is not empty. Else, it will return 鈥榝alse鈥�.

{%= isNotEmpty(profile.mobilePhone.number) %}

Last Index Of last-index-of

The lastIndexOf function is used to return the position (in the first argument) of the last occurrence of the second parameter. Returns -1 if there is no match.

Syntax

{= lastIndexOf(STRING_1, STRING_2) %}: integer

Example

{%= lastIndexOf("hello world","o" ) %}

Returns 7.

Left trim leftTrim

The leftTrim function is used to remove white spaces from beginning of a string.

Syntax

{%= leftTrim(string) %}

Length length

The length function is used to get the number of characters in a string or an expression.

Syntax

{%= length(string) %}

Example

The following function returns the length of the profile鈥檚 city name.

{%= length(profile.homeAddress.city) %}

Like like

The like function is used to determine if a string matches a specified pattern.

Syntax

{%= like(STRING_1, STRING_2) %}

Example

The following query retrieves all the cities where profiles live containing the pattern 鈥渆s鈥�.

{%= like(profile.homeAddress.city, "%es%")%}

Lower Case lower

The lowerCase function converts a string to lower case letters.

Syntax

{%= lowerCase(string) %}

Example

This function converts the profile first name to lower case letters.

{%= lowerCase(profile.person.name.firstName) %}

Matches matches

The matches function is used to determine if a string matches a specific regular expression. Please refer to for more information on matching patterns in regular expressions.

Syntax

{%= matches(STRING_1, STRING_2) %}

Example

The following query determines, without case sensitivity, if the person鈥檚 name starts with 鈥淛ohn鈥�.

{%= matches(person.name.,"(?i)^John") %}

Mask mask

The Mask function is used to replace a part of a string with 鈥淴鈥� characters.

Syntax

{%= mask(string,integer,integer) %}

Example

The following query replaces the 鈥�123456789鈥� string with 鈥淴鈥� characters, excepted for the first and the last 2 characters.

{%= mask("123456789",1,2) %}

The query returns 1XXXXXX89.

MD5 md5

The md5 function is used to calculate and return the md5 hash of a string.

Syntax

{%= md5(string) %}: string

Example

{%= md5("hello world") %}

Returns 鈥�5eb63bbbe01eeed093cb22bb8f5acdc3鈥�

Not equal to notEqualTo

The notEqualTo function is used to determine if a string is not equal to the specified string.

Syntax

{%= notEqualTo(STRING_1, STRING_2) %}

Example

The following query determines, with case sensitivity, if the person鈥檚 name is not 鈥淛ohn鈥�.

{%= notEqualTo(profile.person.name,"John") %}

Not Equal With Ignore Case not-equal-with-ignore-case

The notEqualWithIgnoreCase function is used to compare two strings ignoring case.

Syntax

{= notEqualWithIgnoreCase(STRING_1,STRING_2) %}: boolean

Example

The following query determines if the person鈥檚 name is not 鈥渏ohn鈥�, with no case sensitivity.

{%= notEqualTo(profile.person.name,"john") %}

Regular expression group regexGroup

The Group function is used to extract specific information, based on the regular expression provided.

Syntax

{%= regexGroup(STRING, EXPRESSION, GROUP) %}

Example

The following query is used to extract the domain name from an email address.

{%= regexGroup(emailAddress,"@(\\w+)", 1) %}

Replace replace

The replace function is used to replace a given substring in a string with another substring.

Syntax

{%= replace(STRING_1,STRING_2,STRING_3) %}:string

Example

{%= replace("Hello John, here is your monthly newsletter!","John","Mark") %}

Returns 鈥淗ello Mark, here is your monthly newsletter!鈥�

Replace All replaceAll

The replaceAll function is used to replace all substrings of a text that matches the 鈥渞egex鈥� expression with the specified literal 鈥渞eplacement鈥� string. Regex has special handling of "" and 鈥�+鈥� and all regex expressions follow PQL escaping strategy. The replacement proceeds from the beginning of the string to the end, for example, replacing 鈥渁a鈥� with 鈥渂鈥� in the string 鈥渁aa鈥� will result in 鈥渂a鈥� rather than 鈥渁b鈥�.

Syntax

{%= replaceAll(string,string,string) %}

Right trim rightTrim

The rightTrim function is used removes white spaces from end of a string.

Syntax

{%= rightTrim(string) %}

Split split

The split function is used to split a string by a given character.

Syntax

{%= split(string,string) %}

Starts with startsWith

The startsWith function is used to determine if a string starts with a specified substring.

Syntax

{%= startsWith(STRING_1, STRING_2, CASE_SENSITIVE) %}

Example

The following query determines, with case sensitivity, if the person鈥檚 name starts with 鈥淛oe鈥�.

{%= startsWith(person.name,"Joe") %}

String to date string-to-date

The stringToDate function converts a string value into a date-time value. It takes two arguments: string representation of a date-time and string representation of the formatter.

Syntax

{= stringToDate("date-time value","formatter" %}

Example

{= stringToDate("2023-01-10 23:13:26", "yyyy-MM-dd HH:mm:ss") %}

String to integer string-to-integer

The string_to_integer function is used to convert a string value into an integer value.

Syntax

{= string_to_integer(string) %}: int

String to number string-to-number

The stringToNumber function is used to convert a string into number. It returns the same string as output for invalid input.

Syntax

{%= stringToNumber(string) %}: double

Sub string sub-string

The Count string function is used to return the sub-string of the string expression between the begin index and the end index.
Syntax

{= substr(string, integer, integer) %}: string

Title Case titleCase

The titleCase function is used to capitalize first letters of each words of a string.

Syntax

{%= titleCase(string) %}

Example

If the person lives in Washington high street, this function will return Washington High Street.

{%= titleCase(profile.person.location.Street) %}

To Bool to-bool

The toBool function is used to convert an argument value into a boolean value, depending on its type.

Syntax

{= toBool(string) %}: boolean

To Date Time to-date-time

The toDateTime function is used to convert string to date. It returns the epoch date as output for invalid input.

Syntax

{%= toDateTime(string, string) %}: date-time

To Date Time Only to-date-time-only

The toDateTimeOnly function is used to convert an argument value into a date time only value. It returns the epoch date as output for invalid input. This function accepts string, date, long and int field types.

Syntax

{%= toDateTimeOnly(string/date/long/int) %}: date-time

Trim trim

The trim function removes all white spaces from the beginning and at the end of a string.

Syntax

{%= trim(string) %}

Upper Case upper

The upperCase function converts a string to upper case letters.

Syntax

{%= upperCase(string) %}

Example

This function converts the profile last name to upper case letters.

{%= upperCase(profile.person.name.lastName) %}

Url decode url-decode

The urlDecode function is used to decode a url encoded string.

Syntax

{%= urlDecode(string) %}: string

Url encode url-encode

The Count only null function is used to url encode a string.

Syntax

{%= urlEncode(string) %}: string