fixed width field for export

G

GBA

must export an acii file with defined field widths per the recipient's
demand; thus if LastName field must be 20 and the name is Smith - I must pad
with 15 blank spaces. (not sure if left or right..)

Question:

1. If one defines in the table's field property that the LastName field is
to be 20 character; I presume that does NOT accomplish what is needed and
that the 20 is simply a maximum and the name smith would export with 5
characters - - true or false??

2. The export wizard advance feature will allow one to define the field
width?? Am thinking this is the way to implement...yes?

Welcome friendly advice on this task....TIA
 
F

Fred

Field length alone won't do it. The default for what's beyond their name is
null, not blank spaces.

Export non-delimited should work if all of your exported fields are the same
length and you don't need delimiting characters.
 

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