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



Can I use the advanced search to find field with letters in it

asked on September 12, 2014

I have a field that is called vendor ID.   Some people have been putting names in this field.   Can I run an advanced search to find all docs that have letters in that field instead of numbers? 

0 0


replied on September 12, 2014

You could use a field search here too using a regular expression that finds letters, such as (*[a-zA-Z]*) . The Advanced Search syntax would then be {[]:[vendorID]="*[a-zA-Z]*"}

2 0


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

Sign in to reply to this post.