Left-justify (was Re: Export fixed length)
Kenneth Brody
kenbrody at spamcop.net
Thu Aug 11 13:07:00 PDT 2011
On 8/11/2011 3:10 PM, scooter6 at gmail.com wrote:
> Here is the output of the test file:
>
> 6|27|26317790|3| 5990094586421| 456.00
>
> So, it appears it's creating the proper number of characters per field, but
> the edits themselves aren't doing as they should?
> Strange......
>
> To confirm, I looked at the edits again.....attaching a screen shot to show
> you what they look like in the edit file
[...]
Well, your 0rjdot edit is messed up. While it will right-justify and
zero-fill, it will only remove "space-period-space" sequences that are at
the beginning of the data.
Go into Define Edits on the file that you are running from (_not_ the global
edits), and test both "lj" and "0rjdot". For "0rjdot", use a 10-character
field, and put in "(4 spaces)456.00" and see what happens.
With the edits you listed, it's not possible that the code you posted gives
the results you posted.
--
Kenneth Brody
More information about the Filepro-list
mailing list