chrisbra / csv.vim

A Filetype plugin for csv files
http://www.vim.org/scripts/script.php?script_id=2830
Vim License
1.28k stars 62 forks source link

`:MoveColumn 1 2` only affects first 18 lines of file #207

Closed h3xx closed 2 years ago

h3xx commented 2 years ago

It seems to me that the line 1,1,1,,,,,,,,,,,,,jxy,, makes this stop processing the rest of the file.

Given the following CSV:

Code,Name,Full Name,Specification,Default Warehouse,Default Bin,Safety Stock,Purchase Unit Price,Sales U/P,Drawing Number,Model,Superseded P/N,VehiclType,year,Color,Checker,Attachment,Picture
1.15.01.C3H0.C3H0-110004,"BRACKET, AIR FILTER","1_1.15_1.15.01_1.15.01.C3H0_ BRACKET, AIR FILTER",,,*_*,0,1.7,0,C3H0-110004,CF3100C/P,,,,,,,
1.01.02.8010.8010-160306,CONNECTION JOINT,1_1.01_1.01.02_1.01.02.8010_ CONNECTION JOINT,,spare parts,Bin_R23C5S2B11,0,0.1,0,DJ7021A-2.8-11,CF250T,,,,,,,
1.02.30.0030.0030-142004,"COVER, SMALL AIR CLEANER","1_1.02_1.02.30_1.02.30.0030_ COVER, SMALL AIR CLEANER",,spare parts,*_*,0,0.4,0,1P52MI-A-142004,1P52MI-A,,,,,,,
1.01.80.7020.7020-191002,"DECAL,LEFT FUEL TANK(KORAL BLUE)","1_1.01_1.01.80_1.01.80.7020_ DECAL,LEFT FUEL TANK(KORAL BLUE)",,,*_*,0,0.7,0,7020-191002,CF800-2,,,,,,,
1.01.80.7020.7020-191001,"DECAL,LEFT FUEL TANK(WHITE)","1_1.01_1.01.80_1.01.80.7020_ DECAL,LEFT FUEL TANK(WHITE)",,,*_*,0,0.7,0,7020-191001,CF800-2,,,,,,,
1.01.51.9CR6.9CR6-141100-1BB00,FRONT RACK,parts1_1.01_1.01.51_1.01.51.9CR6_ FRONT RACK,,,*_*,0,26.4,0,9CR6-141100-1,"CF500AU-6L
",,,,,,,
1.02.30.0030.0030-022023,"HOLDER, CONTROL VALVE","1_1.02_1.02.30_1.02.30.0030_ HOLDER, CONTROL VALVE",,spare parts,Bin_R21C5S2B6,0,0.5,0,1P52MI-A-022023,1P52MI-A,,,,,,,
1.01.04.8050.8050-034203,MOUNTING BRACKET,FOOTREST DECK(RH),parts1_1.01_1.01.04_1.01.04.8050_ MOUNTING BRACKET,FOOTREST DECK(RH),,spare parts,*_*,0,2.9,0,805-03.42.03,CF250T-5,,,,,,,
1.01.44.6KJ0.6KJ0-041801,"PROTECTOR,SEAT LOCK","1_1.01_1.01.44_1.01.44.6KJ0_ PROTECTOR,SEAT LOCK",,,*_*,0,0.4,0,6KJ0-041801,CF150-3,,,,,,,
1.01.06.806A.806A-060320-1000,REAR SHOCK ABSORBER(RH),1_1.01_1.01.06_1.01.06.806A_ REAR SHOCK ABSORBER(RH),,spare parts,Bin_R10C2S6B1,0,14.9,0,806A-060320-1,CF250T-6A,,,,,,,
1.02.30.0030.0030-142003,"SPONGE, BREATHER","1_1.02_1.02.30_1.02.30.0030_ SPONGE, BREATHER",,spare parts,Bin_R17C2S3B4,0,0.3,0,1P52MI-A-142003,1P52MI-A,,,,,,,
1.02.52.0800.0800-061005,"""H"" GEAR, DRIVEN","1_1.02_1.02.52_1.02.52.0800_""H"" GEAR, DRIVEN",,spare parts,Bin_R14C1S4B3,0,7,0,0800-061005,2V91W,0800-061005-2000+0800-061004-1000,,,,,,
1.02.52.0800.0800-061005-2000,"""H"" GEAR, DRIVEN","1_1.02_1.02.52_1.02.52.0800_""H"" GEAR, DRIVEN",,,*_*,0,9.4,0,0800-061005-2,2V91W,,,,,,,
1.02.52.0800.0800-061100,"""L"" GEAR, DRIVEN","1_1.02_1.02.52_1.02.52.0800_""L"" GEAR, DRIVEN",,spare parts,Bin_R14C3S4B1,0,18.4,0,0800-061100,2V91W,,,,,,,
1.01.02.8010.8010-190021,09 VERSION STICKER,1_1.01_1.01.02_1.01.02.8010_09 VERSION STICKER,,spare parts,*_*,0,0.3,0,8010-190021,CF250T,,,,,,,
1.01.02.8010.8010-190022,09 VERSION STICKER,1_1.01_1.01.02_1.01.02.8010_09 VERSION STICKER,,spare parts,*_*,0,0.3,0,8010-190022,CF250T,,,,,,,
1,1,1,,,,,,,,,,,,,jxy,,
1.01,1.01,parts1_1.01,,,,,,,,,,,,,jxy,,
1.01.01,1.01.01,parts1_1.01_1.01.01,,,,,,,,,,,,,,,
1.01.01.5020,1.01.01.5020,parts1_1.01_1.01.01_1.01.01.5020,,,,,,,,,,,,,,,
1.01.01.502A,1.01.01.502A,parts1_1.01_1.01.01_1.01.01.502A,,,,,,,,,,,,,,,
1.01.01.502B,1.01.01.502B,parts1_1.01_1.01.01_1.01.01.502B,,,,,,,,,,,,,,,
1.01.01.502D,1.01.01.502D,parts1_1.01_1.01.01_1.01.01.502D,,,,,,,,,,,,,,,
1.01.02,1.01.02,parts1_1.01_1.01.02,,,,,,,,,,,,,,,
1.01.02.5160,1.01.02.5160,parts1_1.01_1.01.02_1.01.02.5160,,,,,,,,,,,,,,,
1.01.02.516H,1.01.02.516H,parts1_1.01_1.01.02_1.01.02.516H,,,,,,,,,,,,,,,
1.01.02.6030,1.01.02.6030,parts1_1.01_1.01.02_1.01.02.6030,,,,,,,,,,,,,,,
1.01.02.603F,1.01.02.603F,parts1_1.01_1.01.02_1.01.02.603F,,,,,,,,,,,,,,,
1.01.02.603G,1.01.02.603G,parts1_1.01_1.01.02_1.01.02.603G,,,,,,,,,,,,,,,
1.01.02.603H,1.01.02.603H,parts1_1.01_1.01.02_1.01.02.603H,,,,,,,,,,,,,,,
1.01.02.603J,1.01.02.603J,parts1_1.01_1.01.02_1.01.02.603J,,,,,,,,,,,,,,,

Issuing the command :MoveColumn 1 2 stops at line 19, resulting in the following CSV:

Name,Code,Full Name,Specification,Default Warehouse,Default Bin,Safety Stock,Purchase Unit Price,Sales U/P,Drawing Number,Model,Superseded P/N,VehiclType,year,Color,Checker,Attachment,Picture
"BRACKET, AIR FILTER",1.15.01.C3H0.C3H0-110004,"1_1.15_1.15.01_1.15.01.C3H0_ BRACKET, AIR FILTER",,,*_*,0,1.7,0,C3H0-110004,CF3100C/P,,,,,,,
CONNECTION JOINT,1.01.02.8010.8010-160306,1_1.01_1.01.02_1.01.02.8010_ CONNECTION JOINT,,spare parts,Bin_R23C5S2B11,0,0.1,0,DJ7021A-2.8-11,CF250T,,,,,,,
"COVER, SMALL AIR CLEANER",1.02.30.0030.0030-142004,"1_1.02_1.02.30_1.02.30.0030_ COVER, SMALL AIR CLEANER",,spare parts,*_*,0,0.4,0,1P52MI-A-142004,1P52MI-A,,,,,,,
"DECAL,LEFT FUEL TANK(KORAL BLUE)",1.01.80.7020.7020-191002,"1_1.01_1.01.80_1.01.80.7020_ DECAL,LEFT FUEL TANK(KORAL BLUE)",,,*_*,0,0.7,0,7020-191002,CF800-2,,,,,,,
"DECAL,LEFT FUEL TANK(WHITE)",1.01.80.7020.7020-191001,"1_1.01_1.01.80_1.01.80.7020_ DECAL,LEFT FUEL TANK(WHITE)",,,*_*,0,0.7,0,7020-191001,CF800-2,,,,,,,
FRONT RACK,1.01.51.9CR6.9CR6-141100-1BB00,parts1_1.01_1.01.51_1.01.51.9CR6_ FRONT RACK,,,*_*,0,26.4,0,9CR6-141100-1,"CF500AU-6L
,",,,,,,
"HOLDER, CONTROL VALVE",1.02.30.0030.0030-022023,"1_1.02_1.02.30_1.02.30.0030_ HOLDER, CONTROL VALVE",,spare parts,Bin_R21C5S2B6,0,0.5,0,1P52MI-A-022023,1P52MI-A,,,,,,,
MOUNTING BRACKET,FOOTREST DECK(RH),1.01.04.8050.8050-034203,parts1_1.01_1.01.04_1.01.04.8050_ MOUNTING BRACKET,FOOTREST DECK(RH),,spare parts,*_*,0,2.9,0,805-03.42.03,CF250T-5,,,,,,,
"PROTECTOR,SEAT LOCK",1.01.44.6KJ0.6KJ0-041801,"1_1.01_1.01.44_1.01.44.6KJ0_ PROTECTOR,SEAT LOCK",,,*_*,0,0.4,0,6KJ0-041801,CF150-3,,,,,,,
REAR SHOCK ABSORBER(RH),1.01.06.806A.806A-060320-1000,1_1.01_1.01.06_1.01.06.806A_ REAR SHOCK ABSORBER(RH),,spare parts,Bin_R10C2S6B1,0,14.9,0,806A-060320-1,CF250T-6A,,,,,,,
"SPONGE, BREATHER",1.02.30.0030.0030-142003,"1_1.02_1.02.30_1.02.30.0030_ SPONGE, BREATHER",,spare parts,Bin_R17C2S3B4,0,0.3,0,1P52MI-A-142003,1P52MI-A,,,,,,,
"""H"" GEAR, DRIVEN",1.02.52.0800.0800-061005,"1_1.02_1.02.52_1.02.52.0800_""H"" GEAR, DRIVEN",,spare parts,Bin_R14C1S4B3,0,7,0,0800-061005,2V91W,0800-061005-2000+0800-061004-1000,,,,,,
"""H"" GEAR, DRIVEN",1.02.52.0800.0800-061005-2000,"1_1.02_1.02.52_1.02.52.0800_""H"" GEAR, DRIVEN",,,*_*,0,9.4,0,0800-061005-2,2V91W,,,,,,,
"""L"" GEAR, DRIVEN",1.02.52.0800.0800-061100,"1_1.02_1.02.52_1.02.52.0800_""L"" GEAR, DRIVEN",,spare parts,Bin_R14C3S4B1,0,18.4,0,0800-061100,2V91W,,,,,,,
09 VERSION STICKER,1.01.02.8010.8010-190021,1_1.01_1.01.02_1.01.02.8010_09 VERSION STICKER,,spare parts,*_*,0,0.3,0,8010-190021,CF250T,,,,,,,
09 VERSION STICKER,1.01.02.8010.8010-190022,1_1.01_1.01.02_1.01.02.8010_09 VERSION STICKER,,spare parts,*_*,0,0.3,0,8010-190022,CF250T,,,,,,,
1,1,1,,,,,,,,,,,,,jxy,,
1.01,1.01,parts1_1.01,,,,,,,,,,,,,jxy,,
1.01.01,1.01.01,parts1_1.01_1.01.01,,,,,,,,,,,,,,,
1.01.01.5020,1.01.01.5020,parts1_1.01_1.01.01_1.01.01.5020,,,,,,,,,,,,,,,
1.01.01.502A,1.01.01.502A,parts1_1.01_1.01.01_1.01.01.502A,,,,,,,,,,,,,,,
1.01.01.502B,1.01.01.502B,parts1_1.01_1.01.01_1.01.01.502B,,,,,,,,,,,,,,,
1.01.01.502D,1.01.01.502D,parts1_1.01_1.01.01_1.01.01.502D,,,,,,,,,,,,,,,
1.01.02,1.01.02,parts1_1.01_1.01.02,,,,,,,,,,,,,,,
1.01.02.5160,1.01.02.5160,parts1_1.01_1.01.02_1.01.02.5160,,,,,,,,,,,,,,,
1.01.02.516H,1.01.02.516H,parts1_1.01_1.01.02_1.01.02.516H,,,,,,,,,,,,,,,
1.01.02.6030,1.01.02.6030,parts1_1.01_1.01.02_1.01.02.6030,,,,,,,,,,,,,,,
1.01.02.603F,1.01.02.603F,parts1_1.01_1.01.02_1.01.02.603F,,,,,,,,,,,,,,,
1.01.02.603G,1.01.02.603G,parts1_1.01_1.01.02_1.01.02.603G,,,,,,,,,,,,,,,
1.01.02.603H,1.01.02.603H,parts1_1.01_1.01.02_1.01.02.603H,,,,,,,,,,,,,,,
1.01.02.603J,1.01.02.603J,parts1_1.01_1.01.02_1.01.02.603J,,,,,,,,,,,,,,,

Version tested: eb284c4e33b57fc828012cb9ebb420a9ae6ecbe7 (2022-01-12) Vim version: 9.0

Output from `vim --version` (45 lines) ``` VIM - Vi IMproved 9.0 (2022 Jun 28, compiled Jun 28 2022 12:44:46) macOS version - arm64 Compiled by Homebrew Huge version without GUI. Features included (+) or not (-): +acl +file_in_path +mouse_urxvt -tag_any_white +arabic +find_in_path +mouse_xterm -tcl +autocmd +float +multi_byte +termguicolors +autochdir +folding +multi_lang +terminal -autoservername -footer -mzscheme +terminfo -balloon_eval +fork() +netbeans_intg +termresponse +balloon_eval_term +gettext +num64 +textobjects -browse -hangul_input +packages +textprop ++builtin_terms +iconv +path_extra +timers +byte_offset +insert_expand +perl +title +channel +ipv6 +persistent_undo -toolbar +cindent +job +popupwin +user_commands -clientserver +jumplist +postscript +vartabs +clipboard +keymap +printer +vertsplit +cmdline_compl +lambda +profile +vim9script +cmdline_hist +langmap -python +viminfo +cmdline_info +libcall +python3 +virtualedit +comments +linebreak +quickfix +visual +conceal +lispindent +reltime +visualextra +cryptv +listcmds +rightleft +vreplace +cscope +localmap +ruby +wildignore +cursorbind +lua +scrollbind +wildmenu +cursorshape +menu +signs +windows +dialog_con +mksession +smartindent +writebackup +diff +modify_fname -sodium -X11 +digraphs +mouse -sound -xfontset -dnd -mouseshape +spell -xim -ebcdic +mouse_dec +startuptime -xpm +emacs_tags -mouse_gpm +statusline -xsmp +eval -mouse_jsbterm -sun_workshop -xterm_clipboard +ex_extra +mouse_netterm +syntax -xterm_save +extra_search +mouse_sgr +tag_binary -farsi -mouse_sysmouse -tag_old_static system vimrc file: "$VIM/vimrc" user vimrc file: "$HOME/.vimrc" 2nd user vimrc file: "~/.vim/vimrc" user exrc file: "$HOME/.exrc" defaults file: "$VIMRUNTIME/defaults.vim" fall-back for $VIM: "/opt/homebrew/share/vim" Compilation: clang -c -I. -Iproto -DHAVE_CONFIG_H -DMACOS_X -DMACOS_X_DARWIN -g -O2 -D_REENTRANT -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=1 Linking: clang -L. -fstack-protector-strong -L/opt/homebrew/lib -L/opt/homebrew/opt/libyaml/lib -L/opt/homebrew/opt/openssl@1.1/lib -L/opt/homebrew/opt/readline/lib -o vim -lm -lncurses -liconv -lintl -framework AppKit -L/opt/homebrew/opt/lua/lib -llua5.4 -mmacosx-version-min=12.0 -fstack-protector-strong -L/opt/homebrew/Cellar/perl/5.34.0/lib/perl5/5.34.0/darwin-thread-multi-2level/CORE -lperl -L/opt/homebrew/opt/python@3.10/Frameworks/Python.framework/Versions/3.10/lib/python3.10/config-3.10-darwin -lpython3.10 -framework CoreFoundation -lruby.3.1 -L/opt/homebrew/Cellar/ruby/3.1.2/lib ```
chrisbra commented 2 years ago

I might be missing something, but starting from line 19, column 1 and 2 are exactly the same. so we just don't see that something has moved, right?

h3xx commented 2 years ago

I might be missing something, but starting from line 19, column 1 and 2 are exactly the same. so we just don't see that something has moved, right?

Yes, that appears to be the case.

Closing issue due to the fact it was an optical illusion.