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:
Account Level – Applies to all mailboxes.
Mailbox Level – Overrides account-level settings for a specific mailbox.
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.
Changing the decimal separator at mailbox-level
Open your mailbox
Click on Settings
Scroll to the bottom of the General tab
Click Save
Changing the decimal separator at template-level
Open your template
Click on Settings
Change the separator
Click Update
Frequently Asked Questions (FAQs)
Why do the list and object views show different separator output?
When you choose the Number format for fields, Parseur converts them into “real” numbers that computers can process. In most technology, numbers always use a dot (.) as the decimal separator.
In the Object view, we display the raw data as extracted, so you’ll see it formatted as defined in your settings above.
In the List view, however, we aim to present a friendlier format by applying localized thousands and decimal separators based on your web browser’s language settings. If your browser settings are in a European language, the decimal numbers are displayed with a comma (e.g., “123,45”).
If you download the data (e.g., into Excel), the underlying number remains “123.45”, but Excel will format it using your local settings.