title: SED: Replacing String After Single Quote
body: <p>I have a file named <code>file.txt</code> that contains the following:</p>
  
  <pre><code>CREATE LARGE TABLESPACE LONGSPCE1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
       USING (FILE '/db2data1/TGT_INST/TGT_DB/LONGSPCE1.c1' 1588368,
              FILE '/db2data2/TGT_INST/TGT_DB/LONGSPCE1.c2' 1588368,
              FILE '/db2data3/TGT_INST/TGT_DB/LONGSPCE1.c3' 1588368,
              FILE '/db2data4/TGT_INST/TGT_DB/LONGSPCE1.c4' 1588368)
  </code></pre>
  
  <p>I am trying to change the numerics after  the <code>c[0-9]'</code> to a value of 100.</p>
  
  <p>I have tried the following with no luck.</p>
  
  <pre><code>cat file.txt |sed 's/(c1'' )\([0-9]*\)/$1 100/g'
  </code></pre>