Option |
Description |
Delimiter |
Specifies the delimiter to use for the file - CSV, Tab or other. Tab delimited exports are useful for importing into Excel. You can specify a hex column delimiter with 0xaa, where aa is the ascii code. Example: 0x5E. |
Delimit Strings with |
Allows you to specify a character used to enclose string values. “ is often used here. When using Column Delimiters it is a good idea to use this option. This avoid the problems that would happen if your data contains the delimiter character (eg. the comma). |
Remove delimiter character from strings |
Your export file can be invalid of your data contain the Delimit Strings with character. Use this option to remove these characters from your string. |
Remove newline characters from strings |
Your export file can also be formed incorrectly if your data contains linefeed characters. Select this option to remove these from your data. |
Note that CSV stands for comma-separated variables and refers to a Delimited File where delimiter character is a comma.