Hi, I want to edit a csv file with e.g. following content:
"tag2",2011/10/31,28250,28208,0,0,0.9985 "tag1",2011/10/31,1591,1583,8,0,1 "tag2",2011/10/30,15046,15008,0,0,0.9975 "tag1",2011/10/30,981,975,6,0,1 "tag2",2011/10/29,13019,12993,0,0,0.998 "tag1",2011/10/29,401,401,0,0,1 "tag2",2011/10/28,8687,8674,0,0,0.9985 "tag1",2011/10/28,1245,1233,12,0,1 "tag2",2011/10/27,8117,8108,0,0,0.9989 "tag1",2011/10/27,703,697,6,0,1 "tag2",2011/10/26,8327,8318,0,0,0.9989 "tag1",2011/10/26,496,496,0,0,1 "tag2",2011/10/25,0,0,0,0,0 "tag1",2011/10/25,973,971,2,0,1 "tag2",2011/10/24,0,0,0,0,0 "tag1",2011/10/24,823,823,0,0,1 "tag2",2011/10/23,0,0,0,0,0 "tag1",2011/10/23,1938,1936,2,0,1 "tag2",2011/10/22,0,0,0,0,0 "tag1",2011/10/22,968,968,0,0,1 "tag2",2011/10/21,0,0,0,0,0 "tag1",2011/10/21,526,526,0,0,1 "tag2",2011/10/20,0,0,0,0,0 "tag1",2011/10/20,828,828,0,0,1 "tag2",2011/10/19,0,0,0,0,0 "tag1",2011/10/19,1079,1079,0,0,1 "tag2",2011/10/18,0,0,0,0,0 "tag1",2011/10/18,850,849,1,0,1 "tag2",2011/10/17,0,0,0,0,0 "tag1",2011/10/17,2056,2056,0,0,1 "tag2",2011/10/16,0,0,0,0,0 "tag1",2011/10/16,1545,1542,3,0,1 "tag2",2011/10/15,0,0,0,0,0 "tag1",2011/10/15,1801,1783,18,0,1 "tag2",2011/10/14,0,0,0,0,0 "tag1",2011/10/14,1651,1644,5,0,0.9988 "tag2",2011/10/13,0,0,0,0,0 "tag1",2011/10/13,1785,1785,0,0,1 "tag2",2011/10/12,0,0,0,0,0 "tag1",2011/10/12,2071,2071,0,0,1 I want to get rid of all lines ending on 0,0,0,0,0 I want to replace all ',' by ';' I want to replace all '.' by ',' With three individual commands, all is ok: :%g/0,0,0,0,0/d :%s/,/;/g :%s/\./,/g The end result is (as expected): "tag2";2011/10/31;28250;28208;0;0;0,9985 "tag1";2011/10/31;1591;1583;8;0;1 "tag2";2011/10/30;15046;15008;0;0;0,9975 "tag1";2011/10/30;981;975;6;0;1 "tag2";2011/10/29;13019;12993;0;0;0,998 "tag1";2011/10/29;401;401;0;0;1 "tag2";2011/10/28;8687;8674;0;0;0,9985 "tag1";2011/10/28;1245;1233;12;0;1 "tag2";2011/10/27;8117;8108;0;0;0,9989 "tag1";2011/10/27;703;697;6;0;1 "tag2";2011/10/26;8327;8318;0;0;0,9989 "tag1";2011/10/26;496;496;0;0;1 "tag1";2011/10/25;973;971;2;0;1 "tag1";2011/10/24;823;823;0;0;1 "tag1";2011/10/23;1938;1936;2;0;1 "tag1";2011/10/22;968;968;0;0;1 "tag1";2011/10/21;526;526;0;0;1 "tag1";2011/10/20;828;828;0;0;1 "tag1";2011/10/19;1079;1079;0;0;1 "tag1";2011/10/18;850;849;1;0;1 "tag1";2011/10/17;2056;2056;0;0;1 "tag1";2011/10/16;1545;1542;3;0;1 "tag1";2011/10/15;1801;1783;18;0;1 "tag1";2011/10/14;1651;1644;5;0;0,9988 "tag1";2011/10/13;1785;1785;0;0;1 "tag1";2011/10/12;2071;2071;0;0;1 But I want to combine these three operations in one command: :%g/0,0,0,0,0/d|%s/,/;/g|%s/\./,/g but this gives following result: "tag2";2011/10/31;28250;28208;0;0;0;9985 "tag1";2011/10/31;1591;1583;8;0;1 "tag2";2011/10/30;15046;15008;0;0;0;9975 "tag1";2011/10/30;981;975;6;0;1 "tag2";2011/10/29;13019;12993;0;0;0;998 "tag1";2011/10/29;401;401;0;0;1 "tag2";2011/10/28;8687;8674;0;0;0;9985 "tag1";2011/10/28;1245;1233;12;0;1 "tag2";2011/10/27;8117;8108;0;0;0;9989 "tag1";2011/10/27;703;697;6;0;1 "tag2";2011/10/26;8327;8318;0;0;0;9989 "tag1";2011/10/26;496;496;0;0;1 "tag1";2011/10/25;973;971;2;0;1 "tag1";2011/10/24;823;823;0;0;1 "tag1";2011/10/23;1938;1936;2;0;1 "tag1";2011/10/22;968;968;0;0;1 "tag1";2011/10/21;526;526;0;0;1 "tag1";2011/10/20;828;828;0;0;1 "tag1";2011/10/19;1079;1079;0;0;1 "tag1";2011/10/18;850;849;1;0;1 "tag1";2011/10/17;2056;2056;0;0;1 "tag1";2011/10/16;1545;1542;3;0;1 "tag1";2011/10/15;1801;1783;18;0;1 "tag1";2011/10/14;1651;1644;5;0;0;9988 "tag1";2011/10/13;1785;1785;0;0;1 "tag1";2011/10/12;2071;2071;0;0;1 Note that all 0.99 get changed into 0;99 rather than 0,99 Is this an error or do I hit some limitation in combining commands? I have hlsearch on, and at the end of this combined command all '.' characters are highlighted when undoing the change. So the last thing searched was indeed '.' and I do not understand why it seems to be replaced with ';' rather than ',' Please advise. TIA, Guido. -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
