I have a field that is supposed to be 11 characters. Unfortunately, there are some that are not entered correctly. How do I search to find those that do not match?
Question
Question
find fields that do not match desired format
Answer
Try this in a custom search
{LF:Name="*", Type="D"} & {[]:[FieldName]<>"???????????"}
That should give you any documents that have a value that does not have exactly 11 characters, excluding those where the field is completely empty.
You might want to add syntax to target a specific folder if you have a large repository, but this could be used in both the client and Workflow.
Replies
In workflow,
1. Do a search in workflow for documents with that field.
2. Have a routing decision where the conditions check for a 'match regular expression' of \w\w\w\w\w\w\w\w\w\w\w if they are word characters. Or replace the \w with just a . if its any character.
Have those that match stay where they are and have those that don't send shortcuts to a folder or do whatever you wish as to where you can find and fix them.