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?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
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…
