Skip to main content
Solved

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

  • September 1, 2023
  • 1 reply
  • 276 views

spiderman
Contributor
Forum|alt.badge.img+7

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

 

Best answer by nielsgerrits

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)

 

View original
Did this help you find an answer to your question?

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • September 1, 2023

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)

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings