a guest Nov 18th, 2018 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //crystal report
  2. //formula- remove lines(concat all words)
  3. stringvar output := propercase({@address});
  4. output := Trim(output);  //get rid of leading & trailing spaces
  5. output := Replace(output,Chr(13),' ');  //get rid of line feed character
  6. output := Replace(output,Chr(10),'');  //get rid of carriage return character  
  7. output := Replace(output,'   ',Chr(13));
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand