about fieldSeparator

flexmonster.connectTo({
dataSourceType: ‘ocsv’,
filename: RptStockDataAnalysisReportAPI.queryString + queryParam,
fieldSeparator: ‘*’
});
fieldSeparator: ‘*’,it is does not work,tell me why please 

1 answer

Public
Tanya Gryshko Flexmonster December 11, 2018

Hello, Jack,
Thank you for your interest in Flexmonster Pivot!
In case the data source contains asterisks for fields separators, like in the following example,

d*s
2*3

such field separator should be specified when compressing the data. For example, Data Compressor for PHP has a compressFile method for compressing the data from files:

Compressor::compressFile("data.csv");

If data.csv has asterisks for fields separators, "*" should be passed as a second argument to the compressFile method:

Compressor::compressFile("data.csv", "*");

The same goes for Data Compressors for other technologies. Please let me know if it helps.
Regards,
Tanya

Please login or Register to Submit Answer