Data conversion

Travis Roy travis at scootz.net
Wed Jan 8 13:17:13 EST 2003


Let me just layout exactly what I do.. I didn't want to get to specific,
but I guess it's needed :)

We get files from all over for mailing lists.. They come in just about any
format you can imagine on just about any media.. 90% of them are either
Excel, or CSV. Sometimes we get CSV files that are to large for Excel to
handle.

Right now what I do is take the file and load it up in Excel, clean up the
sizes of the fields and then save them as space delimited.. This gives me
a fixed width file. Now sometimes if there is to many fields then it just
chops it off and I lose some data, or like I said, the file is to long. In
those cases I load them up into dBase, load up the data, then output it to
a SDF (standard data file). The problem with this is that each field is 30
chars long and I already mentioned why that can be a problem.



More information about the gnhlug-discuss mailing list