space filled field in fixed length file

[sjs]

I have field to export that either will have 8 characters or will be blank. I
need the blank records to keep the 8 character position as this is a fixed
length file. I could use the help.

 

[DrEvil]

best way to do this is utilizing space() function, you can read about it bit
more online, I wouldn't suggest writing spaces to the table but rather on fly
in a query, for example set up your query that will be used for export. I
would create the column in query called FixedExportField:[YourField] &
Space(8-len([YourField])

I haven't tried it so you might need to do some tweeking.

Amir