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