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 "regxPatter n" 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.j t

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)