Solved

Converting rich long text to comma separated text

Hello! I have a long text field with information captured as rich text:

Achievement 1

Achievement 2

Achievement 3

I need these Achievements converted to a comma separated text field. How do I get the above, converted to the below?:

Achievement 1, Achievement 2, Achievement 3

Appreciate any guidance!!!

Best answer by Justin_Barrett

Try this:

SUBSTITUTE(
    SUBSTITUTE(
        TRIM({Field Name}),
        "- ", ""
    ), "\n", ", "
)

Did this topic help you find an answer to your question?

+20

Try this:

SUBSTITUTE(
    SUBSTITUTE(
        TRIM({Field Name}),
        "- ", ""
    ), "\n", ", "
)

Justin_Barrett wrote:

Try this:

SUBSTITUTE(
    SUBSTITUTE(
        TRIM({Field Name}),
        "- ", ""
    ), "\n", ", "
)

Perfect, thank you!!!

Sign up