[RBASE-L] - Carriage Return Removal from Text String

[Sharon Lima]

Hi All,

 

I am working on exporting data from an R:Base table into a CSV file.  

All works well unless a text field has a “carriage return” placed by using
Shift-enter when entering the text data.  

It seems to read the carriage return as a comma which separates the fields
incorrectly.  

 

I tried the following:

 

UPDATE TableName SET ColumnName = (SRPL(ColumnName,'þ','',0))  where þ is my
LINEEND setting.  

 

This was just a stab in the dark and did not work.  Obviously I need some
light on the matter.  

Is there anything I can do to remove the “carriage returns” before I do the
export? 

 

Also, are there any other pitfalls I should know about?

 

Thanks for your help.

 

Sharon Lima