Skip to main content
  • EN

Hello ,

How to convert multi line strings in cell into one line at the same cell ?

I have many cells that include the strings in two lines

at specific cell includes

building CR LF

one side

i want to change the two lines into one line

to be

building one side in one line at the same cell

CR LF : created from Fme ,I am not sure what does it mean ?

fme 2021

 

You can do this using a StringReplacer. Simply open the Text To Replace texteditor, hit Enter on your keyboard and choose for a Space for the Replacement text.

 

CR LF refers to Carriage Return and Line Feed. They are used to note the termination of a line.

 

As an alternative you can use regex to do this, you need something like

(\r\n)

 

Reply


Community Stats

30,162
Posts
114,482
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.