Importing data

Archive of Gamsworld Google Group
Post Reply
Archiver
User
User
Posts: 7876
Joined: 7 years ago

Importing data

Post by Archiver »



Hi,

I've been working with GAMS for just a couple of weeks and I would
like to ask for some help.
I have to import data from a .txt file to a .gms file. The data in
the .txt file has not a specific format and I do not need to import
all data from the .txt file. Are there any functions to readout
specific cells from the .txt file?

Thanks a lot!

Peter Nunster
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to gamsworld@googlegroups.com
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en
-~----------~----~----~----~------~----~------~--~---


Archiver
User
User
Posts: 7876
Joined: 7 years ago

Re: Importing data

Post by Archiver »



No. But GAMS comes with some utilities for manipulating text files.
Some of the more popular tools are sed and awk. The web offers a few
tutorials for these utilities. Moreoever, there is an excellent book
http://oreilly.com/catalog/9781565922259/ about sed & awk. Take a look
at model awkqap, awktsp, and seders in the GAMS model library.

Hope this helps.

Michael Bussieck - GAMS World Coordinator

On Sep 9, 5:37 am, peternun wrote:
> > Hi,
> >
> > I've been working with GAMS for just a couple of weeks and I would
> > like to ask for some help.
> > I have to import data from a .txt file to a .gms file. The data in
> > the .txt file has not a specific format and I do not need to import
> > all data from the .txt file. Are there any functions to readout
> > specific cells from the .txt file?
> >
> > Thanks a lot!
> >
> > Peter Nunster
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to gamsworld@googlegroups.com
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en
-~----------~----~----~----~------~----~------~--~---


Post Reply