From: Oleg Komarov on
Hi,
I have an example cellstring:

names = {'Excel, Statistical Analysis With... - Gupta - 2002 - VJ BOOKS.pdf'
'Derivative pricing, Financial Mathematics. An introduction to... - Hughston, Hunter - 2000 - Book.pdf'};

I want to use regular expressions to rearrange the title of the names in this way:
'Statistical Analysis With Excel - Gupta - 2002 - VJ BOOKS.pdf'
'Financial Mathematics. An introduction to Derivative pricing - Hughston, Hunter - 2000 - Book.pdf'

The part which follows <,> is swapped to the beginning and it loses the final <... > (note the blank after the dots) and the <,> itself is removed too.

The structure of the entire name usually follows the scheme:
title - Author/s (separated by <,>) - year - edition (optional; ex: 2nd ed.) - publisher

Is there any solution with regexprep and similar?

Thank you in advance

Oleg