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!!!
Try this:
SUBSTITUTE(
SUBSTITUTE(
TRIM({Field Name}),
"- ", ""
), "\n", ", "
)
Try this:
SUBSTITUTE(
SUBSTITUTE(
TRIM({Field Name}),
"- ", ""
), "\n", ", "
)
Perfect, thank you!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.