Remove all comma after a word

[Ultralightbeam]

How to remove all comma from a string

Input	Output
Financial Force,,,,,	Financial Force
Financial Force,Sales Force,,,	Financial Force,Sales Force

basically removes all comma on the right side but not comma inbetween of a word

[Emil_Kos]

Hi @Ultralightbeam,

My solution works like this. If there 2 or more, I am removing them and as the last step, I am checking if the last sight is ' and if it is I am removing it as well.

Please let me know if this works for you. 

This is the output:

[Ladarthure · Accepted solution]

Hi @Ultralightbeam,

here is my solution, I used regex to change multiple "," by one and then if it ends with a "," I just remove the last char.

[Ultralightbeam]

@Emil_Kos 

I just found out that I also have two or more commas inbetween the words

Input	Output
Financial Force,,,,,	Financial Force
Financial Force,Sales Force,,,	Financial Force,Sales Force
Financial Force,,Sales Force,,	Financial Force,Sales Force

[Emil_Kos]

Hi @Ultralightbeam,

Small amendment and it works

[Ladarthure]

@Ultralightbeam,

additionnaly, you could use the function

TrimRight([Field1], ',')

which will remove the character specified on the right of your field! (there is also trimleft for the left part and trim to trim both on the left and the right

Have a great day