Previous Topic

Next Topic

Book Contents

Book Index

Export to Delimited File

export_csv

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.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.