Export Data node handles variable names containing comma ",", when exporting data as CSV file

Export Data node handles variable names containing comma ",", when exporting data as CSV file

book

Article ID: KB0083249

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.2, 13.3

Description

When exporting spreadsheet as comma separated CSV file using Export Data node for dataset with variable names containing comma ",", version 13.0 and 13.1 do not take account of the comma "," in the variable names. As a result, in the exported CSV file, the comma in the variable names mix up with the CSV separator comma, which gives a problem in parsing variable names when reloading the exported CSV file using Import Text node.

User-added image
User-added image

This problem has been resolved in version 13.2 and 13.3, where, the Export Data node is able to detect the comma in the variable names and automatically add double quote to that special variable names in the exported CSV file. Such that, the variable names would not be messed up when further reloading the exported CSV file with Import Text node. 

User-added image

Issue/Introduction

Version 13.2 and 13.3 are able to handle variable names containing comma ",", when exporting spreadsheet as comma separated CSV file using Export Data node

Environment

Windows 7, Windows Server 2012 R2