You are viewing limited content. For full access, please sign in.

Question

Question

find fields that do not match desired format

asked on June 9, 2017

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?

0 0

Answer

SELECTED ANSWER
replied on June 9, 2017 Show version history

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.

0 0
replied on June 9, 2017

That works too.  You can add a OR statement with | {[]:[FieldName]<>" "} to also get the empty.

0 0

Replies

replied on June 9, 2017

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.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.