Available Formatters
- Numeric
Turns numbers written any way into a plain number, dropping currency symbols, spaces and thousand separators. - Date
Converts dates into ISO 8601 (YYYY-MM-DD), including dates written in other languages. - RegExp
Rewrites a value with a regular expression. Use it to strip prefixes, remove separators, or keep only part of a value. - Classification
Restricts a field to a set of categories, such as document type or a signed/not signed state. - Match & Map
Matches the value against a list of known values and optionally replaces it with a mapped value. The list can be edited in a table, imported from CSV, or fetched from your own URL.
Some formatters are added for you rather than picked from the list. When your agent is built, fields that hold a currency, a country or a gender get a Currency, ISO Alpha-2 country code or Gender formatter, which enforces the valid values for that field and falls back to
Unknown.