export fixed length and append

Robert T. Repko (R Squared Consultants) rtr at rsquared.com
Tue Mar 1 05:17:36 PST 2011


Thanks Ken, that's what I ended up doing and it works ... with 1 
exception, which I was able to work around.  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.

Maynbe that was fixed in a later release.  I'll have to talk to my 
client about upgrading.

Believe it or not at 2/28/2011 12:00 PM, Kenneth Brody said:
>On 2/28/2011 11:27 AM, Robert T. Repko (R Squared Consultants) wrote:
>>Running filepro 4.8 (it's what the client has so I am stuck using it)
>>that needs to export several fixed length files that need to be
>>appended.  The -X flag is for fixed length, the -A flag is for
>>append, the problem is they appear to be mutually exclusive.
>>
>>If I execute 'export ASCII vip=c:\tmp\vipexport.txt -X -A'
>>I get a fixed length file but the second export does not append, it
>>overwrites.
>>
>>If I execute 'export ASCII vip=c:\tmp\vipexport.txt -A -X'
>>the files append but they are not fixed length.
>>
>>Any ideas on how export fixed length AND append several files.
>
>This is a bug that was fixed in 5.0.14:
>
>>(All) #714
>>
>>     EXPORT ASCII with both "-a" and "-x" flags didn't work.
>
>If you're stuck on 4.8, then I would suggest sticking with "-A" for 
>append, and then exporting a single fixed-length field which you 
>build as appropriate.
>
>--
>Kenneth Brody

***************************
* 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