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