title: Crystal Reports - Remove Carriage Returns
body: <p>I am writing a report for my company right now and am running into issues with one data set in particular. Our accounting team puts unnecessary (as I see it) carriage returns when typing in data in one of our MISC_COMMENT fields. </p>
  
  <p>Example data:</p>
  
  <p>2 Returns</p>
  
  <p>For warping</p>
  
  <p>Cost = $1</p>
  
  <p>RGA# 123</p>
  
  <p>This comes out on the report as such... The report requester has asked that the data be as follows:</p>
  
  <p>2 Returns For Warping Cost = $1 RGA 123</p>
  
  <p>Is there anyway to strip out the carriage returns? Data will vary in characters and length. Not sure if a substring is still applicable then?</p>
  
  <p>Thanks for the help!</p>