Export fixed length
scooter6 at gmail.com
scooter6 at gmail.com
Wed Aug 10 14:36:00 PDT 2011
Thanks Mike - that's exactly what's needed -- doesn't really follow their
own syntax in their examples, but at least it works
Much appreciated
Scott
On Wed, Aug 10, 2011 at 5:06 PM, Mike Schwartz <mschw at athenet.net> wrote:
> > 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
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20110810/3d055354/attachment.html
More information about the Filepro-list
mailing list