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