Hi Every one, my requirement is to remove the null columns in line, comma delimiter used
For example,

Code:

A,11,20,30,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

B1,,,,,, gem,plum,kite,,,,gud,bad,,,,,,,,,,,,,
B2,kiing,kong,height,,,,,,,,,,,,,,,,,,,,,,,,,rak,,,,,,,,,,,,,

B1,,,,,, gem,plum,kite,,,,gud,bad,,,,,,,,,,,,,
B2,kiing,kong,height,,,,,,,,,,,,,,,,,,,,,,,,,rak,,,,,,,,,,,,,

C,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,20

Here A and C are constant, B1 and B2 lines will be repeated many times, In line A i need to remove all the ',' after the value 30 and in line
B1 we have 5 nulls before value'Gem' i need to remove that and also remove all the ',' after rak, same for B2 and C

Logic like foreach line get A (iF A SH then Cut $1 to $5), can some one help me to fix this.

---------- Post updated at 01:50 PM ---------- Previous update was at 01:17 PM ----------

can some one help please !!!!