export wizard

G

Guest

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?
 
G

Guest

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 |:>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top