Menu
Download Free Trial

csv delimiters

Some of our records contain commas in the field. Is it possible to use other delimiters rather than commas. Like a tab or pipe?
Thanks

2 answers

Public
Ian Sadovy Flexmonster March 10, 2016

Hello Paul,
 
Thanks for the question.
Yes, it’s possible. Please check examples below.
 
XML config:

<config>
...
  <dataSource type="csv">
    <filename>data.csv</filename>
<fieldSeparator>|</fieldSeparator>
  </dataSource>
...
</config>

Or JavaScript:

flexmonster.setReport({
dataSourceType: "csv",
filename: "data.csv",
fieldSeparator: "|"
});

Please let me know if you find it helpful.
 
Regards,
Ian

Public
Tanya Gryshko Flexmonster December 5, 2016

Hello Paul and all Flexmonster users,
In version 2.3 Report Object was structured. Properties were logically grouped into sub-objects. For example, all related to data sources properties are inside dataSource sub-object now. Find more details in the documentation: Report Object.
Regards,
Tanya

Please login or Register to Submit Answer