<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Ken,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Your the best. That's all I needed.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>As usual I respond to the list once a problem has
been solved in order to share my findings so others may learn.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The Problem:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Resolution:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ken suggested: A(10)=""{xx to left
justify.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Simple resolution which I should have thought
of.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks again.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Dennis Malen</FONT></DIV>
<DIV><FONT face=Arial size=2>516.479.5912</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>