How to remove comma at the end of a concatenated string?

[richleeb2]

I have the following fields with emails separated by a comma.  Some (not all) of them have a comma at the end.  How do I get rid of that using formula tool?

john@test.com,kate@test.com,jill@test.com,

kelly@test.com,

mike@test.com

[acarter881]

Here's one solution (see attached workflow). Writing a formula to check if the last character is a comma, then taking all of the characters except the last one (i.e., the comma).

[gautiergodard]

You could use this formula:

if EndsWith([YourField], ",") then trimright([YourField],",")
else [YourField]
endif

[Garabujo7]

Hello @richleeb2 , you may use the formula Replace([Field1],","," ")

But I think is better use the text-to-columns, splitting to rows.

Gabriel

[DataNath · Accepted solution]

No need for the if statements - TrimRight() will just ignore records without a trailing comma so you can just use:

TrimRight([Input],',')

(Obviously replace [Input] with your own field name).

[MarqueeCrew]

@DataNath 

That's an answer that I can applaud,

m

[richleeb2]

Thank you this was simple and worked!

[Matthew]

Here's another option that uses regex

REGEX_Replace([Field1], '(.*),$', '$1')