Help

Converting rich long text to comma separated text

Solved
Jump to Solution
1005 2
cancel
Showing results for 
Search instead for 
Did you mean: 
nisha_elliott
5 - Automation Enthusiast
5 - Automation Enthusiast

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!!!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Try this:

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

Screen Shot 2021-07-04 at 2.07.26 PM

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

Try this:

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

Screen Shot 2021-07-04 at 2.07.26 PM

Perfect, thank you!!!