Text Files (CSV etc)
Once any <Text> file type is selected, the following text formatting options will be available:
Option Descriptions
| 1. | Option to add the run date to the file name created. Primarily for easy future identification and also enables using an Export Template (Advanced and Premium editions) repeatedly without over-writing the file |
| 2. | Typically the default value for this is a comma, however in some cases (primarily in international regions), the CSV separator character used can be different. If a CSV file is selected and the "list separator" character is not a comma, CGX will change the file type to that of CDH/CDN using the list separator character for the regional setting as the delimiter. |
| 3. | For Custom Delimited files, up to a 2 character delimiter can be entered |
| 4. | Any of the valid Windows settings can be selected which will automatically set new default formats for date, number and date fields. For example: |
| 5. | Select the date to be used: |
| 6. | Indicates whether <Time> is to be included with date fields |
| 7. | Indicates whether <Time> is to be shown with a 12 or 24hr clock (if Time is selected) |
| 8. | If <Custom Date> format is selected, actually date format can be over-ridden using standard date formatting rules. When <short> or <long> date format is selected, this will show the format that will be used on output based on the Regional setting selected. Some examples: |
| 9. | If <Include Time> is selected, can customize the format of the date field using standard time formatting rules |
| 10. | Select whether leading zeros are to be included for numeric fields |
| 11. | "Numeric Group" format based on the regional setting selected |
| 12. | Thousand's separator to be used in numeric fields |
| 13. | Decimal separator to be used in numeric fields |
| 14. | Numeric field decimal places (where appropriate) ranging from 0-6 |
| 15. | Negative numeric format to be used where applicable |
| 16. | Select whether leading zeros are to be included for currency fields |
| 17. | "Currency Group" format based on the regional setting selected |
| 18. | Thousand's separator to be used in currency fields |
| 19. | Decimal separator to be used in currency fields |
| 20. | Currency field decimal places ranging from 0-6 |
| 21. | Indicate whether or not currency is to be included on output |
| 22. | Select whether currency symbol is to be included on output |
| 23. | Select positive currency field format |
| 24. | Select negative currency field format |
| 25. | Show samples of various fields based on the regional and/or custom settings currently selected |
| 26. | Displays sample output format based on the type of field selected |
