Skip to main content

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

  • June 25, 2019
  • 3 replies
  • 178 views
P
AIMMS Partner
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
Forum|alt.badge.img+1
  • Arthur
  • Former AIMMSian
  • 26 replies
  • July 2, 2019
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
Forum|alt.badge.img+1
  • Arthur
  • Former AIMMSian
  • 26 replies
  • October 7, 2019
@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
AIMMS Partner
  • pai.b.pradeep
  • Author
  • AIMMS Partner
  • 1 reply
  • October 7, 2019
@Arthur Thanks for the update. Will look forward to updates in the Road map section.


Terms & ConditionsAccessibility statement

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

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