Export ASCII R=\N -X
Nancy Palmquist
nancy.palmquist at vss3.com
Thu Jan 16 11:18:56 PST 2020
John,
The r=\n means add a CR/LF which is your two extra characters.
You want to leave that out and just have:
export ascii file=XXXXXXX -x
That will do it. Make sure the variable that you write into the file is
exactly 750 characters.
Nancy
On 1/15/2020 2:32 PM, JohnMac via Filepro-list wrote:
> Running filepro 5.8 on windows10
>
>
>
> Creating ascii fixed length file for IRS which must be 750 characters
>
> Using export ascii fil = C:\appl\test-file. R=\N -X it creates the file
> required
>
>
>
> To check the file, I created a non-filepro file linked to the file
> C:\appl\test-file which is 1 field, 752,* instead of 750
>
> It loads the data to view and verify. Had to add 2 characters to the
> non-filepro fixed length file to view the data file otherwise it wraps the
> records.
>
> Are the extra 2 characters "-|" it loads at the end of the file a
> carriage return and line feed or what are they and how do they affect the
> length of the data file?
>
>
>
> John McNaughton
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200115/810be0fc/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200116/bc6aa127/attachment.html>
More information about the Filepro-list
mailing list