Export to not include trailing spaces

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

I do a transfertext file to an .asc. It is creating
trailing spaces and I need those eliminated in the
transfertext. Is there something I could do in the export
specification or would I need to include some code in the
query? Each record may have a different amount of letters
in the field. How do I eliminate the trailing spaces?

For example:
RBC Dain........./
RBC Dain Rauscher/

I want it to look like:
RBC Dain/
RBC Dain Rauscher/

Thank you!
Shannon
 
Hi Shannon,

Can you give a bit more information about what you're doing? If you're
exporting to a delimited textfile, TransferText doesn't create trailing
spaces, and if you're exporting to a fixed-width file the spaces are
required to keep the fields lined up.

If you have trailing spaces in the table and don't want to export them,
create a query that uses the Trim() function in calculated fields to
return the data without them. In the query design grid they will look
like this:

fMyField: Trim([MyField])
 
Back
Top