Skip to main content
Format parsed data as a number

Convert and format fields into numbers, decimals and integers

Updated over a month ago

Prerequisite

This article assumes you know how to use field formats to normalize and format your data in Parseur. Check out this article for more information.

Number format

Parseur lets you easily parse numbers (including spaces, commas, etc) into real numbers using the Number format.

The "Number" format will transform any number represented in a text into a "real" number.

It will strip out any space, commas and additional formatting characters from the number.

Setting the decimal separator

Parseur needs to determine whether a number uses a dot (.) or a comma (,) as the decimal separator. For example, it must know if 123,456 represents 123 thousand (123 456) or 123 point four five six (123.456).

By default, Parseur will automatically detect the correct decimal separator for each document. If it can’t confidently determine the separator, it will default to your user settings.

You can customize these settings at three levels:

  1. Account Level – Applies to all mailboxes.

  2. Mailbox Level – Overrides account-level settings for a specific mailbox.

  3. Template Level – Overrides both account and mailbox settings for individual templates.

Settings at the template level have the highest priority, followed by mailbox-level, and then account-level settings.

Changing the decimal separator globally at account-level

Go to your account settings and update the Decimal separator configuration.

Change decimal separator setting at account level

Changing the decimal separator at mailbox-level

  • Open your mailbox

  • Click on Settings

  • Scroll to the bottom of the General tab

  • Click Save

Change decimal separator settings at mailbox level

Changing the decimal separator at template-level

  • Open your template

  • Click on Settings

  • Change the separator

  • Click Update

Did this answer your question?