export wizard

J

jrenzul

Can anyone tell me why the export wizard left-justifes numeric fields when
exporting to a fixed width flat file, then adds 2 decimals onto the end? Is
there any way to fix this?
 
C

CyberTaz

Hi JR-

Point 1- AFAIK all fields in a fixed width text file are flush left because
the character count begins on the left. When imported by another data program
the values will typically be aligned right.

Point 2- The two decimal places are most likely because of the definition of
the field in the table where the values are stored. If the field was defined
this way for a reason, it is probably better to not "fix" it because the
field would need to be re-defined. On the other hand if that field will never
be used to store other than Integers, the field is not defined correctly in
the first place.

Hope this is useful |:>)
 
Top