Good morning all,
Here is an interesting challenge.
Spot Versions are manually entered and client wants FM to proof check them for consistency.
Spot Version have two parts:
Version Number (1 thru 99)
Index which is a series of Texts
VERSION# & lowercase letter & Alt or Rev & Number & Alt or Rev & Number
They want no spaces
They want Alt and Rev to be Title Case
There can also be a lowercase Letter after the number
Everything after the number is optional
The issue is that editor will not format it correctly:
For example instead entering 8aAltRev they enter 8a alt rev. or 8a ALT REV, and so on.
So I want to let them enter whatever they want and then upon exiting field a script will fix the entry.