Reading a column from .csv file having data with standard JSON quotes

  • 25 June 2019
  • 3 replies
  • 168 views
P
Rank
Hi everyone,

I was trying to read a column from .csv file which contains data with standard JSON quotes ("). The CSV reader in AIMMS ignores all the characters after the quotes. Anyone knows a fix?

3 replies

Arthur
Userlevel 4
Badge +1
Hi @pai.b.pradeep , it's a limitation of the CSV provider at the moment. A quick workaround would be to turn your file into an Excel file, and use the AIMMSXLLibrary.

We will consider a fix and get back to you soon ! Thanks for reporting !
Arthur
Arthur
Userlevel 4
Badge +1
@pai.b.pradeep This is a feature not currently being considered unfortunately, but keep an eye on Roadmap section for updates. Thanks again for sharing.
Arthur
P
Rank
@Arthur Thanks for the update. Will look forward to updates in the Road map section.

Reply


Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator