function to trim commas between a string

[phanikumar]

Hi All,

I have a requirement where in I need to strip the commas between a string.

Example:

Input:
EQ001,,EQ002,EQ003,,EQ020

The output should be like

EQ001,EQ002,EQ003,EQ020

Any suggestions would be greatly helpful.

Regards
Kumar

[ray.wurlod]

Use the pxEreplace() function you can find here on DSXchange.

[bhasds]

Hi Phanikumar,

I was able to get the desired output with-

Code: Select all

Convert(" ",",",CompactWhiteSpace(Convert(","," ","colname")))

[PhilHibbs]

Use the pxEreplace() function you can find here on DSXchange.

I would wait until this thread is resolved before using pxEreplace.