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
function to trim commas between a string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Sep 20, 2011 10:44 pm
- Location: INDIA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Phanikumar,
I was able to get the desired output with-
I was able to get the desired output with-
Code: Select all
Convert(" ",",",CompactWhiteSpace(Convert(","," ","colname")))
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
I would wait until this thread is resolved before using pxEreplace.ray.wurlod wrote:Use the pxEreplace() function you can find here on DSXchange.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant