Over the years our County has changed the way they record official documents and the numbering systems and the way they indicated these on the document itself. Unfortunately, previous staff have followed short-hand for the naming of these documents. 5 and 6 length documents were added during a set period of years (what I am calling an era) and then 6 and 7 length names were set for a different set. They are all stored in the repository under each year, so I can manually run the workflow for each era to maintain track of which documents have been renamed.
I need to write a workflow to change the Entry name from the short-hand way to the actual name as the County (called a Reception #). I am struggling with how to do the following Conditional tests:
1) If the length of the Entry Name is 5 characters, leave it alone...it is an error and must be manually rectified. (I will probably test for this and set a flag to easily find them later).
2) If the length of the Entry Name is 6 characters, add the 4 char Year field to the entry name and re-save with the new name
3) If the length of the Entry Name is 7 or more characters, or has an F character in space one, leave it alone. It is valid and correct.
I was thinking that a regular expression may get me what I need, but they are not my strong point, yet.