Problem with multi-line rich text fields
I'm experiencing a problem when importing data from a csv file into a rich field. The import process combines all lines in a field into one line.
The same thing happens if using Update Multiple Records, and specifying a formula to copy the fields. For example:
Text1 is a multi-line field.
Text2 is a rich text2 field.
When updating multiple records, I put this formula into Text2: Text1
The result was that all of contents of Text1 were added to Text2, but all lines within a field were combined into one line.
-
Please import into the multiline Text (Text1).
Birger
-
I can do that. But how can I copy the data from there into the Text2 field, and still retain multiple paragraphs?
-
Hi Chuck,
You can use the following formula in the function "Update multiple records" to transfer the content of a "Multiline text" field with the line breaks into a "Rich text" field:
replace('Text (mehrzeilig)', "", "<br>")Kind regards, Jörg
-
I don't understand what "mehrzeilig" is.
-
Hi Chuck,
-> multi line
(that's only the name of my multi line text field)
Best, Jörg
-
Ok, thanks!
-
That didn't work, but this did:
replace(text (Text1), "
", "<br>")Thanks for pointing me in the right direction.
-
Add-On -
Everything else works... eg from the "Fonts" menu... eg Bold, Underline...
Also from the "right click" menu: eg "Transformations" and then Upper Case, Lower case, Capitalise etc etc
-
sorry!!!! answer to the wrong question !!!!