How to erase newline character from string?

Hello,

I am reading an xml file that contains new line (enter) character. How do I detect and erase it?

 text=a.Olay(1)

 text = 

     "YBasla
      "

As you can see there is a new line character at the end of the string. Erase could not delete it this way:

 erase(text,'↵')

 ans = 

     "YBasla
      "

Note that the string looks like this in a table

 a =

6×5 table

         (...)                     Olay                        (...)                  (...)       (...) 
    _________________    ____________________________    ______________________    _________    __________

         (...)              "YBasla↵"                           (...)                  (...)     (...)

I uploaded table and the text variable so that you can play with them.

[Walter Roberson]

erase(text,char(10))

Question though: is it possible that there are carriage returns as well as newline?

Answer 1

[Stephen23]

strtrim(text)

[Caglar]

Hello, thank you but new line character is not always at the end of beginning, sometimes there are a few in one string.

[Stephen23]

"...but new line character is not always at the end or beginning, sometimes there are a few in one string."

regexprep(text,'\n+','')

or if you want to include carriage return as well (if you use Windows):

regexprep(text,'[\n\r]+','')

[Donavan Haidinger]

When working with the replace function, you might need to use char(10) or newline rather than '\n+'

Example:

table.fieldname = replace(table.fieldname,char(10),' ')

or

table.fieldname = replace(table.fieldname,newline,' ')

Both answers yield the same result