export fixed length and append

[Kenneth Brody]

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