How to rename a series of files within a PLMXML file and Windows folder?

[Roger Housden]

I need to rename a series of files that are both referenced in a PLMXML file and are physically located in a Windows folder. I think that command "regx" or "regxPattern" might be able to do this.

Typical filenames (exported from a database vault) include:

_XvIAA8Trh781nA,EHEAQMHmh781nA_7101366.jt
_VWCAA8A8h781nA,FgHAQMyWh781nA_7101369.jt
_0NHAA4gZh781nA,ETBAQME$h781nA_7101173.jt

Always the same length alphanumeric prefix (location in vault) but not always the same ending number.

Sometimes files have a suffix:

_02AAQMY7h781nA,0bKAQMNah781nA_7101831-01.jt
_USPAQEyEh781nA,V8HAQM0ch781nA_7101657-001.jt
_E2JAQAIxh781nA,E6CAQAIxh781nA_7101406_ALF1.jt

We want all renamed to:

AFCC7101366.jt
AFCC7101369.jt
AFCC7101173.jt

and

AFCC7101831-01.jt
AFCC7101657-001.jt
AFCC7101406_ALF.jt

Is that possible?

Thanks in advance.

Roger.

[Guido Geurs]

Just cut after the second underscore with:

NEWNAME = Mid(OLDNAME, instr(2,OLDNAME, "_") +1)