title: Netsuite - REPLACE function replaces enitre field - not just the character I want to replace
body: <p>In Netsuite I have a mass update to replace all single quotes with the number 20. </p>
  
  <p>I am using the below formula thanks to someone's assistance here earlier but what is happening is the entire text field is being replaced. </p>
  
  <pre><code>REPLACE(CHR(39) || '20', CHR(39) , '20')
  </code></pre>
  
  <p>For example - the field I am mass updating has the following:</p>
  
  <pre><code>Vacation '20
  </code></pre>
  
  <p>Using the above formula instead of getting:</p>
  
  <pre><code>Vacation 2020
  </code></pre>
  
  <p>I am getting:</p>
  
  <pre><code>2020
  </code></pre>
  
  <p>How can I only replace the single quote but leave all else intact?</p>