0

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.

9 replies

null
    • Birger_H
    • 4 yrs ago
    • Reported - view

    Please import into the multiline Text (Text1).

    Birger 

    • chuckhoffman
    • 4 yrs ago
    • Reported - view

    I can do that. But how can I copy the data from there into the Text2 field, and still retain multiple paragraphs?

    • Jorg
    • 4 yrs ago
    • Reported - view

    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

    • chuckhoffman
    • 4 yrs ago
    • Reported - view

    I don't understand what "mehrzeilig" is.

    • Support
    • 4 yrs ago
    • Reported - view

    Hi Chuck, 

    -> multi line

    (that's only the name of my multi line text field) 😉

    Best, Jörg

    • chuckhoffman
    • 4 yrs ago
    • Reported - view

    Ok, thanks!

    • chuckhoffman
    • 4 yrs ago
    • Reported - view

    That didn't work, but this did:

     

    replace(text (Text1), "
    ", "<br>")

     

    Thanks for pointing me in the right direction.

    • Luis
    • 3 yrs ago
    • Reported - view

    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

    • Luis
    • 3 yrs ago
    • Reported - view

    sorry!!!! answer to the wrong question !!!!

Content aside

  • 3 yrs agoLast active
  • 9Replies
  • 1748Views