How to reformat dbf to fixed length wo CR LF?

[dc509]

I need to reformat an address file from a dbf to a fixed length file (to send to our catalog mailing company) with NO Carriage Return or Line Feed characters.

I know I can use COPY TO ... TYPE SDF, but this includes CR/LF.

I'm probably missing something simple.

Thanks

David

BTW, I really like this site. I read the questions and answers about every day. I'm learning a bunch!

 

[mpastore]

USE address

COPY TO address TYPE sdf
aaa=FILETOSTR("address.txt&quot
aaa=STRTRAN(aaa,CHR(13)+CHR(10),"&quot
=STRTOFILE(aaa,"address1.txt&quot && no CR/LF in this file

 

[dc509]

Thanks for the quick response. That worked!

David