string | country_code: <default>  string

Convert a country name string into two-letter, ISO 3166-1 alpha-2 country code. Empty strings are left intact. This conversion understands different ways a country name can be expressed.

• default string
  Optional. Default value to use when string is not recognized as a country. Defaults to an empty string.

string | country_name: <default>  string

Convert different ways a country name can be expressed into a consistent version of the country name. Empty strings are left intact.

• default string
  Optional. Default value to use when string is not recognized as a country. Defaults to an empty string.

number | currency: <symbol>  number

Convert the source value into a given currency symbol using historical EOD exchange rates. Your data source query must be compatible with automatic inclusion of date and currency code fields. See currency conversion for additional details.

• symbol string
  Required. Target currency symbol. Case-insensitive. See fixer.io/symbols for all supported values.

Please note that this filter might not work for all data sources and queries just yet. Let us know of any issues you might encounter.

number | percent  float

Multiply a ratio number by 100 to turn it into a percentage number.

number | ratio  float

Divide a percentage number by 100 to turn it into a ratio number.

any | hmac_sha1: <secret>  string

Converts a string into a keyed SHA-1 hash using the HMAC method. Non-string source values are turned into strings first. Based on a Liquid filter.

• secret string
  Required. Secret key in plain text.

any | hmac_sha256: <secret>  string

Converts a string into a keyed SHA-256 hash using the HMAC method. Non-string source values are turned into strings first. Based on a Liquid filter.

• secret string
  Required. Secret key in plain text.

any | md5  string

Converts a string into an MD5 hash. Non-string source values are turned into strings first. Based on a Liquid filter.

any | sha1  string

Converts a string into a SHA-1 hash. Non-string source values are turned into strings first. Based on a Liquid filter.

any | sha256  string

Converts a string into a SHA-256 hash. Non-string source values are turned into strings first. Based on a Liquid filter.

string | date: <format>  string

Format date with given format. Formatting only works up to the accuracy of the source data - e.g. it's not possible to return hour of the day from a source values displaying just a date.

• format string
  Required. Date format, expecting PHP date format characters.

number | abs  number

Get absolute value from source number. Based on a Liquid filter.

number | at_least: <value>  number

Ensure the source value is at minimum the given number. Return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Minimum number the value should be.

number | at_most: <value>  number

Ensure the source value is at maximum the given number. Return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Maximum number the value should be.

number | ceil  int

Get integer, or next highest integer from a float source value with fractions. Based on a Liquid filter.

number | divided_by: <value>  number

Divide the source value by a given number. Depending on the outcome, return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Number to divide by.

number | floor  int

Get integer, or next lowest integer from a float source value with fractions. Based on a Liquid filter.

number | minus: <value>  number

Subtract a number from the source value. Depending on the outcome, return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Number to subtract from source value.

number | plus: <value>  number

Add a number to the source value. Depending on the outcome, return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Number to add to source value.

number | times: <value>  number

Multiply the source value by a given number. Depending on the outcome, return value can be either an integer or a float. Based on a Liquid filter.

• value number
  Required. Number to multiply source value with.

any | append: <value>  string

Append a string to the end of the source value. Non-string source values are turned into strings first. Based on a Liquid filter.

• value string
  Required. String to append.

any | capitalize  string

Uppercase first letter from the source value. Non-string source values are turned into strings first. Based on a Liquid filter.

any | downcase  string

Turn all characters in the source value into lowercase. Non-string source values are turned into strings first. Based on a Liquid filter.

any | prepend: <value>  string

Prepend a string to the beginning of the source value. Non-string source values are turned into strings first. Based on a Liquid filter.

• value string
  Required. String to prepend.

any | regexp_extract: <pattern>, <group>  string

Replace source value with a matched group from a regular expression pattern. If no match is found, an empty string is used. Non-string source values are turned into strings first.

• pattern string
  Required. Regular expression (PCRE) pattern to look for, with enclosing delimiters.
• group int
  Optional. Index of which matched group should replace the source value. Defaults to 1 for the first matched group.

any | regexp_remove: <pattern>  string

Find and remove all occurrences of regular expression pattern matches from the source value. Non-string source values are turned into strings first.

• pattern string
  Required. Regular expression (PCRE) pattern to look for, with enclosing delimiters.

any | regexp_replace: <pattern>, <replace>  string

Find and replace all occurrences of regular expression pattern matches in the source value with another string. Non-string source values are turned into strings first.

• pattern string
  Required. Regular expression (PCRE) pattern to look for, with enclosing delimiters.
• replace string
  Required. String to replace with.

any | remove: <value>  string

Find and remove all occurrences of a given string from the source value. Searching is case-sensitive. Non-string source values are turned into strings first. Based on a Liquid filter.

• value string
  Required. String to look for.

any | replace: <find>, <replace>  string

Find and replace all occurrences of given string in the source value with another string. Searching is case-sensitive. Non-string source values are turned into strings first. Based on a Liquid filter.

• find string
  Required. String to look for.
• replace string
  Required. String to replace with.

any | slice: <offset>, <length>  string

Extract characters from the source value starting from a given offset position. Non-string source values are turned into strings first. Based on a Liquid filter.

• offset int
  Required. Index to start from, 0-based.
• length int
  Optional. Substring length. Defaults to 1.

any | strip  string

Strip whitespace and new line characters from the beginning and from the end of the source value. Non-string source values are turned into strings first. Based on a Liquid filter.

string | truncate: <length>, <ellipsis>  string

When the source value exceeds given amount of characters, truncate string and append ellipsis to it. The length of the ellipsis is included to the truncation length. Unicode characters consisting of multiple bytes are measured as one character. Based on a Liquid filter.

• length number
  Required. Number of characters to allow.
• ellipsis string
  Optional. Custom ellipsis to append, defaults to "...".

any | upcase  string

Turn all characters in the source value into uppercase. Non-string source values are turned into strings first. Based on a Liquid filter.

any | bool  bool

Convert any non-boolean value into a boolean. Return null when conversion does not identify boolean intent from the value. Conversion understands different positive and negative values, such as words "yes" and "no".

any | float  float

Convert integers and strings into a float number. Return null when conversion is not possible. When value is a string, recognize numeric strings formatted with a thousands separator, with a currency symbol, and with a percentage sign.

any | string  string

Convert any value to into a string. Float values will loose unnecessary trailing decimals. Null values are turned into empty strings.

any | default: <value>  any

Use given default value when source value is null, false, 0 or an empty string. Based on a Liquid filter.

• value any
  Required. Default value to use