I have data in txt file (al most 300 +/- rows)like this
Acct:001000,IMP,180 A: $23656.00 D: $56458.00
Acct:001100,EXP,403 B: $59555.00 E: $165879.00 G: $45565.00
I need to put these information in file like
001000,IMP,180,23656.00,,,56458,,,
001100,EXP,403,,59555.00,,,165879.00...