By default, ControlPoint uses a comma (,) as a delimiter to separate data in search and analysis results when the Download Report Data as CSV option is used. ControlPoint Application Administrators can, however, specify a different delimiter to use by modifying the Value of the ControlPoint Setting CSV Delimiter Character. (This might be necessary if some of the content in analysis resultssuch as site namescontain commas.)
Note that this setting does not apply when the CSV (comma delimited) option in selected from the report toolbar drop-down.
NOTE: This is an Advanced Setting.
NOTE: If you want to use a tab for the delimiter, enter TAB.
If you use a delimiter other than a comma and plan to use Excel as your analysis tool, when performing the Download Report Data as CSV operation, choose the [Save] option then import the saved file into Excel. If you try to open the csv file directly in Excel, only commas will be recognized as delimiters.