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

  • 25 June 2019
  • 3 replies
  • 158 views

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

Userlevel 4
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 !
Userlevel 4
@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 Thanks for the update. Will look forward to updates in the Road map section.

Reply


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

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