<div> Thanks - that works too -- didn't realize you needed the new line before the -x</div>
<div> </div>
<div> One more thing - how do you 'left justify, blank fill' a field?</div>
<div> I created a Global edit as such:</div>
<div> </div>
<div> LJ = {#}\ \ <-- hoping the space between the \ would create blanks after the numbers</div>
<div> </div>
<div> I'm creating a file that is fixed length - but the field can be a variety of numbers long -- but the fixed length is 17 characters</div>
<div> So I need to left justify, blank fill this field.....</div>
<div> </div>
<div> That edit didn't work.......anyone have syntax for a left justify field?</div>
<div> </div>
<div> Scott<br><br></div>
<div class="gmail_quote">On Wed, Aug 10, 2011 at 6:03 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:KandLBrody@gmail.com">KandLBrody@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div class="h5">On 8/10/2011 5:06 PM, Mike Schwartz wrote:<br>>> Trying to create an export (fixed length) using following syntax:<br>>><br>>> export ascii ach=/appl/fpmerge/achtest.txt -X r=\n<br>>><br>
>> then do all my field assignments, etc<br>>><br>>> ach(1)=1;ach(2)=2...etc<br>>><br>>> When the file is created it's not adding a line feed after each record?<br>>><br>>> I have tried with and without the r=\n ??<br>
>><br>>> When looking at the output file, it just lists the records one after the<br>> other<br>>><br>>> i.e. file looks like:<br>>><br>>> 627065400153 45496004627314074269 104280298<br>
>> ^ new record should start here<br>>><br>>> Should look like:<br>>><br>>> 627065400153 45496004<br>>> 627314074269 104280298<br>
>><br>>> Why is it not adding the line feed?<br>>><br>>> Thanks for any insight<br>>><br>>> Scott<br>><br>> With the -X option, as I recall, you have to add your own carriage<br>
> return/linefeed (or whatever you want to terminate each record with)<br>> yourself.<br>><br>> For example, you need a line like:<br>><br>> ach(10)=chr("13") {chr("10")<br>><br>
> at the end of the fields you are writing, if you want a DOS formatted<br>> file.<br><br></div></div>Note that, on Windows, that will get you a double-spaced file. And, on<br>*nix, this will give you a file with a spurious Ctrl-M at the end of each<br>
line. All you want is CHR("10").<br><br>However, you shouldn't need that at all, as the following works just fine<br>for me:<br><br>==========<br> Then: export ascii foo = /temp/foo.txt r=\n -x<br> Then: foo[1] = 1<br>
Then: foo[2] = 2<br> Then: foo[3] = 3<br>==========<br><br>This gives me the following output:<br><br>==========<br>Brody Ken 11/17/2009<br>smith john 11/21/2009<br>
obama barack 06/21/2010<br>smith john 06/21/2010<br>==========<br><font color="#888888"><br>--<br>Kenneth Brody<br>_______________________________________________<br>
Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</font></blockquote></div><br>