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