How to remove all comma from a string InputOutputFinancial Force,,,,,Financial ForceFinancial Force,Sales Force,,,Financial Force,Sales Force basically removes all comma on the right side but not comma inbetween of a word

Remove all comma after a word

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

Transformation

Accepted answers

Ladarthure

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.

parsing comas.yxmd

All comments

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:

Test2.yxmd

Ladarthure

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.

parsing comas.yxmd

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335