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.
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.
Environment
Windows 7, Windows Server 2012 R2
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