title: Parsing log lines using awk
body: <p>I have to parse some information out of big log file lines.
  Its something like</p>
  
  <pre><code>abc.log:2012-03-03 11:12:12,457 ABC[123.RPH.-101] XYZ: Query=get_data @a=0,@b=1 Rows=10Time=100   
  </code></pre>
  
  <p>There are many log lines like above in the logfiles. I need to extract information like
            datetime i.e. 2012-03-03 11:12:12,457
         job details i.e. 123.RPH.-101
        Query i.e.   get_data    (no parameters)
       Rows i.e. 10
       Time i.e. 100</p>
  
  <p>So output should look like</p>
  
  <pre><code>2012-03-03 11:12:12,457|123|-101|get_data|10|100  
  </code></pre>
  
  <p>I have tried various permutation computations with awk but not getting it right.</p>