Export fixed length
Mike Schwartz
mschw at athenet.net
Wed Aug 10 14:06:48 PDT 2011
> Trying to create an export (fixed length) using following syntax:
>
> export ascii ach=/appl/fpmerge/achtest.txt -X r=\n
>
> then do all my field assignments, etc
>
> ach(1)=1;ach(2)=2...etc
>
> When the file is created it's not adding a line feed after each record?
>
> I have tried with and without the r=\n ??
>
> When looking at the output file, it just lists the records one after the
other
>
> i.e. file looks like:
>
> 627065400153 45496004627314074269 104280298
> ^ new record should start here
>
> Should look like:
>
> 627065400153 45496004
> 627314074269 104280298
>
> Why is it not adding the line feed?
>
> Thanks for any insight
>
> Scott
With the -X option, as I recall, you have to add your own carriage
return/linefeed (or whatever you want to terminate each record with)
yourself.
For example, you need a line like:
ach(10)=chr("13") {chr("10")
at the end of the fields you are writing, if you want a DOS formatted
file.
Mike Schwartz
More information about the Filepro-list
mailing list