Code:
$ echo ",,,,,6630140,XXXXXXXXXXXXXXX, 0020.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0010.00,USA
,,,,,6630150,XXXXXXXXXXXXXXX(xyz), 1300.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0002648.000012" | sed 's/\(.*, \)\(0*\)\(.*\)/\1\3/'
,,,,,6630140,XXXXXXXXXXXXXXX, 20.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 10.00,USA
,,,,,6630150,XXXXXXXXXXXXXXX(xyz), 1300.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 2648.000012