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
  • 332 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)

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • 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)