trim

thank you so much,

grat........wor ked for me


replace(replace (trim(both ' ' from field),'\t','') ,'\n',' '),