title: awk/sed on csv with #text
body: <p>I am newbie here, so any directions would help. Have a csv file ( comma seprated ) and in one of the columns there is text delimited with # sign ( the column is delimeted by # on it`s own ). Here is an example of a line:</p>
  <pre><code>text,text devicetype,cidr,text#more text#XXXX|more
  text#even more text#more
  text#text_toreplace#text|text#text
  </code></pre>
  <p>text_toreplace is what i want substitued with different text, without changing all the rest of the data in the column with value &quot;text#more text#XXXX|more text#even more text#more text#text_toreplace#text|text#text&quot;</p>
  <p>The CSV does have the first raw as headers and there would be multiple lines after that.</p>
  <p>Sample output would be exactly the same with the coumn dlimted by # and one value differance :</p>
  <pre><code>text,text devicetype,cidr,text#more text#XXXX|more
  text#even more text#more
  text#REPLACED_TEXT#text|text#text
  </code></pre>
  <p>Ideas</p>