You can replace new lines and spaces inside a field with a statement similar to the following:
REPLACE(REPLACE(LTRIM(RTRIM(FIELD_NAME)), CHAR(13), ''), CHAR(10), '')
Visit the DevX Tip Bank
