
Hi guys
Is it possible to extract and display part of a field?
If I insert "{FILENAME \* Upper\* MERGEFORMAT}" into the document footer it returns the entire filename - ie "DOC2072XB" in this instance.
The way the filename is constructed is "DOC2072" is the document reference and "XB" is it's revision. I'd like to be able to display these two items separately.
I tried
"{=left(FILENAME,7) \* Upper\* MERGEFORMAT}" and
"{=right(FILENAME,2) \* Upper\* MERGEFORMAT}"
as a wild guess but it doesn't work!
If I've explained what I want to do properly, and it makes sense, does anyone know if what I want to do it possible? If so, how?
Cheers,
Gary