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