Removing spaces form a csv file

[CSSQL]

Hello all
I need to remove some spaces from a csv and possbily a footer at the bottom. I've tried using some vbs script but none are working. Can anyone help.
This is the example of the vbs script:-
50229020 ,0000033139
43760028 ,0000039153
51582016 ,0000056292
36234016 ,0000071555
58051012 ,0000079645

(11305 rows affected)

 

[MarkSweetland]

Your example data really doesn't express what you are trying to accomplish, nor the expected results. forum329 will help you with VbScript questions...

Please read faq222-2244 to help you get the answers you need.





Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[CSSQL]

Thanks.
sorry the output actuall looked looked like
50229020 ,0000033139
and I wanted it to look like
50229020,0000033139

and also remove the
(11305 rows affected)

 

[CSSQL]

Apologies. I've put this on the worng forum.