A1,B1,C1,,E1,F1 A2,B2,C2,D2,E2,F2 A3,B3,C3,,E3,F3 A4,B4,C4,D4,E4,F4 |
A1,B1,C1,(A1),E1,F1 A2,B2,C2,D2,E2,F2 A3,B3,C3,(A3),E3,F3 A4,B4,C4,D4,E4,F4
|
1. ctrl-o open csv file 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Chars' * set 'replace scope' to 'Line' * set 'search for pattern' to: * set 'replace with pattern' to: 3. click 'replace', done. 4. ctrl-s save to disk. |