vim: delete all words on line except last

Question

I'm having trouble coming up with a vim find/replace to delete all the words on a line except the last one, i.e. in a bit of SQL, it be nice to generate a list of all the aliases from a bunch of code

select 
column_a alias_a,
column_b alias_b,
column_c alias_c

from 
...

I'd like to just generate the list

alias_a, alias_b, alias_c

So I think i want to delete all words that aren't immediately followed by a comma and line ending

Answer 1

option 1:

%s/\v.*\s(\S+)$/\1/

option 2: using macro

qa$T d0jq

then x@a x is how many lines you want to apply this macro

option 3

turn to external command:

:%!awk '$0=$NF'

option 4: if you have Align or similar plugin, align those lines right, then use c-v block select and remove, just leave the last column.