PDM Set Revision to Card Value (value does not match any of the revisions)

We had four complicated work flows involving 4 revision components / schemes for managing our revisions. These included...

1) Internal Pre-IFC releases:

Pre-IFC Alpha, Pre-IFC Numeric (obtained Rev Values of A1, A2, A3, A4,.....Z99)

2) External Pre-IFC releases:

Pre-IFC Alpha (obtained Rev Values of A, B, C, D,.....Z)

3) Internal IFC releases:

IFC Numeric, IFC Alpha (obtained Rev Values of 0A, 0B, 0C, 0D,.....99Z)

4) External IFC releases:

IFC Numeric (obtained Rev Values of 0, 1, 2, 3,.....99)

We wanted to simplify our workflow, so we scrapped the above for two work states

1) State 1 = In Process (meant for editing)

2) State 2 = Locked (meant to Lock the file and set the rev level)

The rev level was simply recorded in the PDM comments during the state transition to "Locked" beside the applicable version.

Version comment = Released as Rev %var_Revision No%

where "Revision No" = the data card value entered by a user.

Now, we'd like to Set the Revision Value to equal Data Card Value. Unfortunately, it appears that we need a Revision component that encompasses our 4 revision schemes. This is where I'm stumped. Any Help?

SolidworksSolidworks Pdm enterprise Pdm