title: Netsuite - How to replace a single quote via mass update
body: <p>I am trying to replace all of the single quotes in a field with the number 20. Basically, the field contains a year but when they were brought into Netsuite it was done so as '20 {for 2020} but we need  to change it to be 2020 instead.</p>
  
  <p>I tried the following formula in the mass update for that field but am getting a syntax error and am not sure why because I thought I was escaping the character correctly:</p>
  
  <pre><code>REPLACE(''''20', ''' , '20')
  </code></pre>
  
  <p>The idea is to replace all of the single quotes where the string is '20 to 2020.</p>
  
  <p>Thanks for any assistance.</p>