How to replace multiple occurrence of comma in a single comma between two substring in SQL Server

Question

I have one input string 'abcdefg,,,,,,,ghijk,,,,,lmno' and we want an output of 'abcdefg,ghijk,lmno' in SQL Server.

Answer 1

Based on this solution you can replace multiple , with a single , like this:

SELECT REPLACE(REPLACE(REPLACE('abcdefg,,,,,,,ghijk,,,,,lmno', ',', '<>'), '><', ''), '<>', ',')

demo on dbfiddle.uk