The Currency Format for Keyword Types configured in a process must match the format of currency in the process file. Some dialog boxes in the Client allow you to specify currency formats, such as Internal and External Text Searching. When clicking on the Format button, the Currency Format dialog box displays. See the table below for a description of General Formatting options.
General Formatting |
|
---|---|
The characteristics defined in the General Formatting section apply to both positive and negative currency values. Note:
Depending on your Currency Format dialog box, you may see a field for ISO formats. You may enter your currency's ISO format (Example: JPY for Japanese Yen, USD for U.S. Dollar). The ISO format Identifier field is used for reference only. |
|
Use Currency Symbol |
Select this option if the value uses a currency symbol, such as a $. Type the symbol used in the Symbol field. Note:
A space in place of a currency symbol is not supported within the Client. |
Use Digit Grouping Symbol |
Select this option if the value uses a digit grouping symbol. A comma (,) is commonly used as a digit grouping symbol (e.g., 1,000,000). |
Digits in Group |
Identifies the number of symbols that are separated by a digit grouping symbol. This number is commonly 3 (e.g., 1,000,000), but can accept 0-6. |
Decimal Symbol |
Identifies the symbol used to identify decimal value spacing. This symbol is commonly a period (.) (e.g., 1,000,000.99). |
Decimal Places |
Identifies the number of digits that follow a decimal symbol. This number is commonly 2, but can accept 0-6 when configuring a process. In all other instances, only 0-2 is accepted. Note:
Currency Keyword Values can only accept 16 digits to the left of a decimal place. |
Positive Numbers |
|
---|---|
Symbol After Number |
Select this option for positive numbers in which the currency symbol (that was specified in the Symbol field) appears after the number (e.g., 1,000.00$). |
Add Space for Symbol |
Select this option if there is a space in the text between the number and the currency symbol (e.g., $1,000.00). |
Negative Numbers |
|
---|---|
Negative Indicators |
Select the character that identifies the value as a negative number. Minus Sign(-) or Parentheses( ). |
Indicator After Number |
Select this option if the negative indicator symbol appears after the value. Applies to minus sign (-) only. |
Symbol After Number |
Select this option if the currency symbol appears after the negative number. |
Symbol Inside Indicator |
Select this option if the currency symbol appears after the value and before the indicator (e.g., 1,000,000 $ - ). Applies to minus sign (-) only. |
Add Space for Symbol |
Select this option if a space ( ) appears after the currency symbol. (e.g., - $ 1,000,000). |