Skip to main content
Vantage can normalize extracted dates, numbers, and money amounts so that values have a uniform format. To normalize data extracted from a field, specify its data type:
1

Open Field options

In the data form, click Field options next to the field.
2

Select a data type

In Field options, select the data type from the Data type dropdown.
For normalization to work, set the data-type-specific properties for each field so that Vantage extracts everything that needs to be normalized. To access these properties, click Advanced in Field options. For more information, see Properties by data type.
Normalized value shown on hover over a field

Hover a field to see its normalized value

​
Normalize dates

When normalizing dates, Vantage converts extracted dates into ISO 8601 format:
  • YYYY-MM-DD for dates
  • HH:MM:SS for time
For more information about accepted separators, see Data types.

​
Examples

If both Day-Month-Year and Month-Day-Year formats are enabled, Vantage may not be able to normalize the date unambiguously. In that case, you can choose between the two candidate dates.
Dates written out in words are normalized only when they’re in English and English is selected in the skill settings. Vantage may not be able to normalize a date in the following cases:
  • The date is incomplete, such as 4:39 am. Time values are normalized only when extracted together with a date.
  • Adverbs of time are used instead of exact dates, such as last month or a few days ago.
  • Extra words or characters appear next to the date or time, such as 2016/06/15 22.
  • Uncommon date representations are used, such as 14 Jumada Al-Awwal 1445.

​
Normalize numbers

Vantage can normalize numbers using Western or Indian digit grouping: Vantage parses the extracted string and converts it into a standardized format using a dot (.) to separate integer and fractional parts. For more information about accepted separators, see Data types.

​
Examples

If the part after the dot has three digits (as in 1.000), you need to choose between the two candidate values. The dot can separate thousands, or the integer from the fractional part.
Numbers written out in words are normalized only when they’re in English and English is selected in the skill settings. Vantage may not be able to normalize a number in the following cases:
  • Extra words or characters appear next to the number, such as EURO12,345.678 or 5 kilos.
  • There is an irregular number of digits between the fractional and integer parts, or between the decimal and thousands parts, such as 123,456,7890. The fractional part must contain 3 or fewer digits. If 123,456,789 is extracted, the normalized value is 123456789. If 123,456,78 is extracted, the normalized value is 123456.78.
  • Irregular number representations are used.

​
Normalize money amounts

A money amount contains a number value and a currency symbol, with the symbol before or after the amount. When normalizing, Vantage outputs the currency symbol first, followed by the amount normalized as a number. Currency is identified by symbol or name. For example, €, EURO, and euros all map to the euro. The normalized value uses the exact symbol or name found in the extracted text.

​
Examples

Amounts written out in words are normalized only when they’re in English and English is selected in the skill settings. Vantage may not be able to normalize a money amount when invalid words are used to denote a currency, such as 12 ttt.