title: find , replace and add a new pattern
body: <p>I have below kind of entries in a file.  While I can easily replace  <code>RAW</code> to <code>VARCHAR</code> as,</p>
  
  <pre><code>awk 'BEGIN{IGNORECASE = 1};{gsub(/RAW/,"VARCHAR")}; 1' 
  </code></pre>
  
  <p>I am trying to find a way to add a pattern after replacement </p>
  
  <p>For example here is my data </p>
  
  <pre><code>COL1    RAW(64)       NOT NULL,    
  COL2    RAW(255)      NOT NULL,
  </code></pre>
  
  <p>here is desired data</p>
  
  <pre><code>COL1    VARCHAR (64)  FOR BIT DATA NOT NULL,    
  COL2    VARCHAR (255) FOR BIT DATA NOT NULL,
  </code></pre>
  
  <p>i.e <code>RAW</code> should be replaced with <code>VARCHAR</code> - this part I am able to do using <code>awk</code>, However I am not sure how to add <code>FOR BIT DATA</code> </p>