Fixed length file & leading spaces

[Dennis Malen]

Ken,

Your the best. That's all I needed.

As usual I respond to the list once a problem has been solved in order to share my findings so others may learn.

The Problem:

A fixed length file is created without the use of -x because we are trying to use -a. All the fields created are exported perfectly, except for the first field which has leading spaces. In that case the field moves left causing the file to be out of sync for the receiver of the file who is expecting a certain length.

Resolution:

If the first field that you are exporting contains leading spaces, the entire line will move left. The field must be left justified in order for the export to work so that the leading spaces are to the right of the information as opposed to the left. The integrity of the number of required spaces will then remain intact.

Ken suggested: A(10)=""{xx to left justify.

Simple resolution which I should have thought of.

Thanks again.

Dennis Malen
516.479.5912
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20041117/91e16196/attachment.html