How to avoid column splitting in CSV report output with Reporter 3.2


Date: 04/25/2025
Categories: SCIEX OS software , Analyst software , MultiQuant software

0 Votes
   Print    Rate Article:

For research use only. Not for use in diagnostic procedures.


Answer

To output a report in CSV format, commas are used between tags to direct data into separate columns. However, when using the outlier reasons tag, the text in the outlier reasons column contains commas between each failed flag, which could be problematic during CSV report generation. As such, each flag listed in the outlier reasons column will be in its own, separate column in the CSV output. To avoid this, the outlier reasons tag is placed inside double quotes. 

 

Below is an example screenshot of the tag for outlier reasons placed inside double quotes, which prevents the generation of extra columns in the CSV report.