//crystal report
//formula- remove lines(concat all words)
stringvar output := propercase({@address});
output := Trim(output);  //get rid of leading & trailing spaces
output := Replace(output,Chr(13),' ');  //get rid of line feed character
output := Replace(output,Chr(10),'');  //get rid of carriage return character
output := Replace(output,'   ',Chr(13));