Rename file pattern windows batch

Question

I have some files looking like following:

ABCD0123_R001_01234567_01234567_01234567-012345.csv

If a run ren *_*_*_*_* *_.* I get:

ABCD0123_R001_01234567_01234567_.csv

But I actually want to get:

ABCD0123_R001_01234567_01234567.csv

There is no documentation if I run ren /? so I would need some help.

Answer 1

If the fields are fixed then try this on some sample files.

ren *.csv ????????_????_????????_????????.*