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, " ")
Bingo - yes this will solve my problem directly 😀
Hi, could you please be more specific? What is not working if using substitute function? That should suit the purpose.
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"
Pardon my ignorance, I see now what you mean by CR LF. Have you tried using trim? This will remove any irregular spaces
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?
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
