pull part of a field out to use in another field?

Hi Folks,
I have  a client with a Field called Document Name that looks like the following. {ag02152004sp} This is the only place that the date is correct for the document and they just want to extract everything after the "ag" and after the "sp" to a text field.  Does anyone know of a way to do this in workflow or autoindex???

Hi Michael,

Using the Mid() function in workflow would do the trick:  Mid(DW_DOCUMENT_NAME, 3, 8)