Custom name column to remove middle of filename?

One of the Regular Expressions column scripts will let you do that.

e.g. This one has a nice UI for setting up the columns:

This one has a long tutorial written about it:

A third option (may also have a config UI; I'm not sure):