Regular expression to remove the last column from a channel delimited file

Question

I have a file with 1000 records and 131 columns, the columns are channel-limited. There is no pipe at the end, so the format is something like.

2010-10-04 | Safety | AMEND | 20162214 | ... more columns ... | Bloomberg

How to delete the last column of a file in Vim?

Answer 1

You need

%s/|[^|]*$// 

Note. I use [^|]*to resolve an empty column.

Answer 2

This regex will catch the last column: \|[^|]+$

Answer 3

:

:%s/.*\zs|.*//

Answer 4

cut awk