export fixed length problem

[Kenneth Brody]

Dennis Malen wrote:
> 
> Ken,
> 
> You solved that problem for me weeks ago.
> 
> I had a problem with the -a which I could not use with -X.

Which has been fixed in the 5.0.14 update.

> You and others suggested the manual approach that I have been using. As a
> matter of fact, I sent you an e-mail thanking you.
> 
> I am using the manual method you told me to use which fixed the append
> problem for fixed length file.
> 
> This would be working perfectly if my first field always contained the same
> number of characters which it does not. All subsequent fields do retain the
> blank spaces as you can see from the file I sent you. It is the first field
> that screws up the process.
> 
> How do I retain blank space on the first field. All subsequent fields work
> fine.

But you are only exporting one field:

    rnf(1)=a&b&c&d&e&f&g&h&chr("10")

The leading spaces from the field are stripped, and there are no trailing
spaces.  (But trailing spaces would have been stripped if there were any.)

Either left-justify field "a", preface the export with something to prevent
it from having leading spaces, or use the "-x" flag.

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody/at\spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+
Don't e-mail me at: <mailto:ThisIsASpamTrap at gmail.com>