second question export -X

Robert T. Repko (R Squared Consultants) rtr at rsquared.com
Mon Feb 28 08:54:45 PST 2011


I failed to mention in my previous post that I am running filepro on 
a Windows system.

As we know export -X should export fixed length fields.  It does that 
except for the last field.  If the last field ends in spaces/blanks 
then the field is exported with a <CR> at the end of the last 
non-blank character, not fixed length.

export ASCII vip=c:\tmp\vipexport.txt -A r=\n
aa(116)=1&2&3&4&5&6&7&8&9&10&11&12&13&14
vip(1)=aa

In order to get the last field to be fixed length I have to remove 
the r=\n and append chr("13") after the last field.

export ASCII vip=c:\tmp\vipexport.txt -A
aa(116)=1&2&3&4&5&6&7&8&9&10&11&12&13&14&chr("13")
vip(1)=aa
write vip

That's the only way I can export fixed length files that 
append.  Comments/suggestions.


***************************
* Robert T. Repko         *
* R Squared Consultants   *
* 4 Juniper Ave.          *
* Easton, PA 18045        *
* (610) 360-1117 (mobile) *
* (610) 253-0725 (fax)    *
*************************** 



More information about the Filepro-list mailing list