The table below explains the items on the Edit export format screen. For information about how to access this screen, see Set the Format Options of an Export Process.
|
Screen Item |
Description |
|
Currency symbol |
On the Currency tab, enter the monetary symbol, such as a “$,” a “£,” or a “” sign, to display to indicate a currency value. |
|
Number of digits after decimal |
Enter the number of digits to display after the decimal in currency values. You can select to display between “0” and “4” decimal places. |
|
Digit grouping symbol |
Under Additional options for CSV output, enter the punctuation, such as a comma, to include in currency values to indicate the 1000s separator. |
|
Decimal symbol |
Under Additional options for CSV output, enter the punctuation, such as a period, to include in currency values to indicate the decimal separator between dollars and cents. Note: These format options apply only to CSV output. Output in XLSX format uses the settings on the user's workstation for the digit grouping symbol and the decimal symbol. |
|
Date format |
On the Date and Time tab, specify the format to use to display complete dates in the exported data. You can select the format from the drop-down list or enter date specifiers to create a new format. Note: The information in the CSV is formatted as specified. For example, if you open the CSV file in a text editor, you can see dates in the date format you specified. However, if you open the CSV file in Excel, Excel tries to recognize what the different fields and values represent and format them according to your system date settings, which may not match the date format you specified. |
|
Fuzzy date format |
Specify the format to use to display incomplete, or fuzzy, dates in the exported data. You can select the format from the drop-down list or enter date specifiers to create a new format. |
|
Month/day format |
Specify the format to use to display dates that include only the month and day in the exported data. You can select the format from the drop-down list or enter date specifiers to create a new format. |
|
Hour/minute format |
Specify the format to use to display times in the exported data. You can select the format from the drop-down list or enter time specifiers to create a new format. You cannot include seconds or timezone offsets in the format. |
| Line break character |
Specify the line break option for your output. This determines how the output separates lines and can be helpful if the default format does not work for your needs. If you have problems when you use the output with a third-party program such as Microsoft Word, change the line break character options and run the process again. Different software programs may expect line break options to follow line feed breaks (LF), carriage return breaks (CR), or both (CR+LF). If you do not know what format your software program requires, you might need to test by trying each option. This field defaults to the line feed (LF) option. |