Manage the large STRING in CRYSTAL REPORT without new line (REMOVE ENTER)

local StringVar myvar;

myvar := replace ({ member.address},chr(13)+ chr(10)," ");

myvar

description :

this code was write in Formula Field of Crystal report

local StringVar myvar it was a local variable declare

StringVar is a DataType in Crytal report

{ member.address} was a database column
chr(13) + chr(10) was a Enter Key

replace ( [original source ] , [find string ] , [replace string ] )

myvar was return