title: Crystal Reports phone numer
body: <p>I'm working in a crystal report and need to format a phone number field. The data I am working with is somewhat messed up and there are some numbers formatted correctly</p>
  
  <p>(111)111-1111</p>
  
  <p>and some 1111111111</p>
  
  <p>I'm trying to write this formula that will remove the parentheses and re-format the string. Here's what I have so far and have no clue why this won't work</p>
  
  <pre><code>StringVar phone = Replace({AssessorTrainingReport;1.Phone1},"(",""); 
  phone := Replace({AssessorTrainingReport;1.Phone1},")","");
  Picture (CStr (phone), "(xxx) xxx-xxxx");
  </code></pre>