My file is in the following format:
this!,is!,another!,test,yes! this!,is!,another!,column,yes! no,not!,another!,column
My output should be:
test column no
It shouldn't contain the '!' character.
I've tried multiple sed and (e)grep commands but none of them are quite working.