Fields with exact number of spaces so spaces show in txt file

C

Craig

Hi,

I need to create several fields filled with different exact number of spaces
so when I join those "space" fields with content fields into 1 long string
and export it to a .txt or .dat file, the exact number of spaces will hold.

Thank you for any assistance!!!
 
C

Clifford Bass

Hi Craig,

Why bother with that when you can export is as a fixed-[field-]width
text file?

There is also the Space(number) function that returns a specified
number of spaces if a fixed-width export does not work for you.

Clifford Bass
 

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

Similar Threads

Import txt file - records on multiple lines 1
How to tell number of spaces between values in saved text file fromthe original xls file 1
How to tell spaces between values in saved text file from theoriginal xls file 2
Format fixed length fields with leading zeros or spaces 5
how do you remove leading spaces etc in cells? 11
Join Properties 5
Missing info when exporting report to txt file 2
imported field has leading spaces 3

Top