export fixed length problem
Dennis Malen
dmalen at malen.com
Wed Nov 17 12:12:45 PST 2004
Ken,
1. I am only exporting one filed because that is how the filePro list
suggested I do it. It was also your suggestion to use the chr("10"). It
works great, except for the first field. You seem to be satisfied with the
logic that all other fields hold the spaces but you are not concerned with
the first field and seem to accept that. Why, I don't know.
2. Trailing spaces are not being stripped on subsequent fields on the same
line. Again, it is only the first field. If I add xx(5) after a(10) then the
5 empty spaces in xx are retained. If I put it in front of a(10) and cause
the xx to be the first field, it is not maintained.
3. I can not use the -X with -a.
4. You say to left justify. Whaaalaaa! You finally got it. That's the
question I have been asking. How do I do it???????????
Regards,
Dennis Malen
516.479.5912
----- Original Message -----
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: "filePro mailing list" <filepro-list at lists.celestial.com>
Sent: Wednesday, November 17, 2004 2:47 PM
Subject: Re: export fixed length problem
> 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>
>
>
>
>
More information about the Filepro-list
mailing list