space filled field in fixed length file

  • Thread starter Thread starter sjs
  • Start date Start date
S

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.
 
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
 
Back
Top