Detect CRLF character in a text line item

CommunityMember126322

I have to replace CRLF (carriage return / line feed) characteres form a text line item.

How can I use the FIND function or more better the SUBSTITUE function to replace such a CRLF char.

Result = SUBSTITUE(line item to replace, CRLF character, " ")

Accepted answers

CommunityMember126322

Bingo - yes this will solve my problem directly 😀

All comments

Alexandru.Rosca

Hi, could you please be more specific? What is not working if using substitute function? That should suit the purpose.

CommunityMember126322

Thanks for your answers, but I want to replace the CRLF character from the text field with a space.

See below in T3 the text is abc abc, where the blank sign between first abc and 2nd abc is the CRLF caharacter.

now with SUBSTITUE function I try to replace the CRLF sign with a blank/space

The CR in the formula should be the CRLF character to replace.

The final result must then be "abc abc"

and not

"abc

abc"

Alexandru.Rosca

Pardon my ignorance, I see now what you mean by CR LF. Have you tried using trim? This will remove any irregular spaces

CommunityMember126322

I found a workaround:

In "Text with CRLF" I added this text:

In the line item "CRLF" I get the CRLF character with the MID function, which then I can use in the SUBSTITUTE function to replace the CRLF in any other text formatted line item (here in "Text to replace")

The question remains: Is there not an easier way to have the CRLF character as a short cut to use in SUBSTITUE without my workaround?

CommunityMember126322

Bingo - yes this will solve my problem directly 😀

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…