<html><head></head><body><div dir="auto">Could you make a second copy of the file and read it separately only opening it based upon your first read? This may not be feasible nor make sense in what you are doing. <br><br></div>
<div dir="auto"><img src="cid:ii_e3786b4049b2466a" width="53" height="63"><!-- tmjah_g_1299s --><!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Rod Caddy<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->817-793-4148 Cell<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->1-877-657-1480<!-- tmjah_g_1299e --><br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Sent from <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15038"><!-- tmjah_g_1299s -->BlueMail<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On May 31, 2019, at 10:27 AM, "Michael Schwartz (PC Support & Services) via Filepro-list" <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="blue">On 5/31/2019 8:08 AM, Michael Schwartz (PC Support & Services) via <br>Filepro-list wrote:<br><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> filePro version 5.8.03.12D6 running on Centos 6<br><br> Before I spend a lot of time writing code to test this, do any of<br></blockquote>you<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> know if I can open the same file with "import ascii" using more than one<br> file handle in the same processing table? Something like:<br><br> Import ascii NewOrder=(FF{"") r=\n f=|<br><br> Import ascii PreCheck=(FF{"") r=\n f=|<br><br> FF is a huge text file with lines containing order numbers and part<br> numbers and I need to "read ahead" through the lines in the file one order<br> at a time to see if the order contains certain part numbers. If these<br> certain part numbers are present in that order, I have to do some<br></blockquote>different<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> things when I start reading and posting the data lines using the<br></blockquote>"NewOrder"<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> file handle.<br><br> I understand that "getnext" and "getprev" don't work with "import<br> ascii". If they did then I wouldn't need to open the file twice.<br><br> If nobody gives me a definitive answer, I will write some test code<br></blockquote>and<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> let you all know how it works out.<br><br> Thanks!<br> Mike Schwartz</blockquote><br>----- -----<hr><br>-- Only if you close the first handle before you open the second.<br><br>-- This file will be open and locked, so the second import will fail as if <br>-- you reach the end of the file.<br><br>-- Richard D. Williams<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"><hr><br></blockquote><br> Ok, thanks! I guess I will have to do something like opening import<br>file, reading it to the end, putting the PO # of those orders that have the<br>odd parts into a dim'ed array, then closing the import file and reopening it<br>to do the posting to the filePro order database, referencing the dimmed<br>array as necessary to handle the posting. <br><br>Mike<br><br><hr><br>Filepro-list mailing list<br>Filepro-list@lists.celestial.com<br>Subscribe/Unsubscribe/Subscription Changes<br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br></pre></blockquote></div></body></html>