Solved

Read and write delimited tabular files

  • 10 November 2022
  • 2 replies
  • 56 views

Userlevel 2
Badge +3

What library is currently (and will be) supported for reading tabular data files that are delimited by specific characters - for e.g., tabs? Is there an option to specify delimiter in the DEX library for mapping these data files? Or, is the best course to use the CSVProvider (depedent on DataLink) and use ReadWriteAttribute?

icon

Best answer by MarcelRoelofs 13 November 2022, 14:40

View original

2 replies

Userlevel 4
Badge +5

Hi @Sree 

The DEX library will guess the delimiter based on the first line, and is tested to work with comma, semi-colon and tab separators. When writing, it will always generate comma-separated files.

The DEX library is currently under full development to become a kind of Swiss army knife for data exchange in AIMMS, supporting reading and writing multiple data formats (JSON, XML, CSV, Excel, Parquet, DB), auto-generated mappings from annotated identifiers, auto-generating application databases capable of storing datasets for multiple scenarios from annotated identifiers (currently under development), generating REST API clients from OpenAPI specifications, exposing model procedures as REST services on our cloud platform, exposing generated application databases through a REST service in our cloud platform (next on roadmap), … 

So, if anything, my bet would be for DEX as the future proof library for data exchange.

 

@MarcelRoelofs -

The DEX library is currently under full development to become a kind of Swiss army knife for data exchange in AIMMS, ...

This is great to see as we look to expanding how we develop and deploy models.

Reply


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

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