Re: Excel spreadsheet to 400, Hummingbird

[Pete Hall <peteh@xxxxxxxxxx>]

At 11:55 01/07/1999 -0500, Kathie wrote:
>First of all, thanks in advance for any help received. I have an Excel
>spreadsheet that has multiple columns totaling 322 characters. It had multiple
>sheets, so I did a 'save as' and deleted the unnecessary sheets. I formatted
>the cell widths to exact whole numbers, and padded the first row fields out to
>proper lengths with X's. So if field had 'ABCD' and it was a 10 char field, I
>padded it as 'ABCDXXXXXX'. I did a 'save as' different types. The only one
>that worked and FTP'd into a undelimited flat file on the 400 that I could
>copy to the correct file with *nochk was when I saved as Formatted Text, space
>delimited. This saved it as a .prn file. All was well, except that it cut the
>length to 240, even though I had proper padding. My client has Hummingbird. I
>need this file uploaded asap.... can anyone help? 

There's a utility on my web site that will do it if the target file is also
text format - only alpha and zoned decimal fields. It will produce a flat
record image from a tab delimited text file, which is a standard Excel
export option. For unsigned numeric data, I generally format the column
with an edit word containing all zeros for the desired field width and tell
the utility that it's just a text field. For signed data, you need to
reserve an extra byte for the sign, which can be either leading or
trailing, but must be present, even if the value is positive. There's help
text that explains what's happening. It's in Programming | Downloads. It's
called "flatulate" in honor of all the fun I've had fighting this same battle.

hth
Pete
Pete Hall
peteh@inwave.com
http://www.inwave.com/~peteh
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---