csv delimiters

posted on March 10th, 2016

Answered

Paul Schlichter asked on March 10, 2016

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

csv delimiters

2 answers

Please login or Register to Submit Answer