title: Sharepoint: Calculated Column replace all spaces
body: <p>Seems like it would be a simple thing really (and it may be), but I'm trying to take the string data of a column and then through a calculated column, replace all the spaces with %20's so that the HTML link in the workflow produced email will actually not break off at the first space.</p>
  
  <p>For example, we have this in our source column:</p>
  
  <p><strong>file:///Z:/data/This is our report.rpt</strong></p>
  
  <p>And would like to end up with this in the calculated column:</p>
  
  <p><strong>file:///Z:/data/This%20is%20our%20report.rpt</strong></p>
  
  <p>Already used the REPLACE, and made up a ghastly super nested REPLACE/SEARCH version, but the problem there is that you have to nest for EACH potential space, and if you don't know how many up front, it doesn't work, or will miss some.</p>
  
  <p>Have any of you come across this scenario and how did you handle it?</p>
  
  <p>Thanks in advance!</p>