I have a string value which I need to get the middle bit out, e.g. "Cancel Payer" / "New Paperless".
These are an example of the string format:
"REF_SPHCPHJ0000057_Cancel Payer_20100105174151.pdf"
"REF_SPHCPHJ0000056_New Paperless_20100105174151.pdf"