Pastable version of Slow bash for loop.

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17</pre>
            <pre class="sunburst">SCRIPT=<span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>gen_<span style="color:#8A9A95;"><span style="color:#8A9A95;">${</span>1<span style="color:#8A9A95;">}</span></span>.sql<span style="color:#65B042;">&quot;</span></span>
echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>--gen_<span style="color:#8A9A95;"><span style="color:#8A9A95;">${</span>1<span style="color:#8A9A95;">}</span></span>.sql<span style="color:#65B042;">&quot;</span></span> <span style="color:#E28964;">&gt;</span> <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>SCRIPT</span>
typeset -i counter
counter=0

echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>Get all lines that start with D|4| (this may take a while)<span style="color:#65B042;">&quot;</span></span>
LINES=<span style="color:#65B042;"><span style="color:#65B042;">$(</span>grep <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>D|4|<span style="color:#65B042;">&quot;</span></span> <span style="color:#8A9A95;"><span style="color:#8A9A95;">$</span>1</span><span style="color:#65B042;">)</span></span>

echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>Generate insert statements to <span style="color:#8A9A95;"><span style="color:#8A9A95;">$</span>SCRIPT</span><span style="color:#65B042;">&quot;</span></span>
<span style="color:#E28964;">for</span> LINE <span style="color:#E28964;">in</span> <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>LINES</span><span style="color:#E28964;">;</span> <span style="color:#E28964;">do</span>
  REFNO=<span style="color:#65B042;"><span style="color:#65B042;">$(</span>echo <span style="color:#8A9A95;"><span style="color:#8A9A95;">$</span>LINE</span> <span style="color:#E28964;">|</span> awk <span style="color:#65B042;"><span style="color:#65B042;">'</span>{split($0,a,&quot;|&quot;);print a[8]}<span style="color:#65B042;">'</span></span><span style="color:#65B042;">)</span></span>
  echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>insert into CHEQUE (datecomptable, noreference) values (to_date('2007/11/30','YYYY/MM/DD'),'<span style="color:#8A9A95;"><span style="color:#8A9A95;">${</span>REFNO<span style="color:#8A9A95;">}</span></span>');<span style="color:#65B042;">&quot;</span></span> <span style="color:#E28964;">&gt;&gt;</span> <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>SCRIPT</span>
        counter=counter+1
<span style="color:#E28964;">done</span>

echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>commit;<span style="color:#65B042;">&quot;</span></span> <span style="color:#E28964;">&gt;&gt;</span> <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>SCRIPT</span>
echo <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span><span style="color:#8A9A95;"><span style="color:#8A9A95;">${</span>counter<span style="color:#8A9A95;">}</span></span> records created in <span style="color:#8A9A95;"><span style="color:#8A9A95;">$</span>SCRIPT</span><span style="color:#65B042;">&quot;</span></span>
</pre>
          </div>
        </div>

<a href="http://refactormycode.com/codes/229-slow-bash-for-loop" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://refactormycode.com/images/small_logo.gif" style="border:0" /></a>

counter free hit invisible