Report Actions › Export Reports to Spreadsheets › Set Up the Export Options › Set Up Column Delimiters Pane

Set Up Column Delimiters Pane

The Delimited export method specifies the character that you want to use to break the report into columns. A new column break is placed in the data at each delimiter. The delimiters can be comma, tab, or space and so on.

For example, If you have the text, “Sample 1, Sample 2, Sample 3” on a line, a comma delimiter would break the text into three cells or columns in your spreadsheet as, “Sample 1”, “Sample 2” and “Sample 3”..

Note:

• To see the Setup Column Delimiter Pane, you must select the Delimited option for Export Method in the first step, Export Options.
• You can select more than one delimiter to break the report fields into columns.

Complete the following information, if your selection is Delimited:

Setup Column Delimiters

Creates columns based on the following options:

Tab

Creates the columns in report data based on tab separated values.

Comma

Creates the columns in report data based on comma-separated values.

Space

Creates the columns in report data based on space separated values.

Semicolon

Creates the columns in report data based on semicolon separated values.

Other String

Creates the columns in report data based on the specified delimiter character in the field provided.

Treat consecutive delimiters as single column break

Treats consecutive delimiters as one. For example, if you select Space Delimited and select this check box, five consecutive spaces do not create five column breaks, but rather one column break.

The Delimited export method is set up. Go to the next step in the wizard, Set Up the Column Details, to continue the export process.