How to use more than one single character wildcard in search?

I have a standard for computer names which consists of 2 characters for support group, 3 characters for department, 3 characters of unique LU and 6 additional characters.  I want to search for the unique LU,  which would seem to be _____ABC which I would think to be 5 single characters followed by ABC, but this doesn't work.  _%_%_%_%_%ABC doesn't work.  %ABC would find it, but would also find any other computer with ABC anywhere in the name.  I really don't want to return all computers with ABC in the name and make the user choose which one is right.  Any thoughts?

2 Comments   [ + ] Show comments
  • Try systemname regex .{5}ABC - flip1001 2 years ago
  • You are describing a search that ends with ABC, but there are six characters after the ABC, correct? Also, are you searching in the Inventory using an advanced search or with a query? Keep in mind that Smart Labels use a query in the backend, so if you are making a smart label that matters. - chucksteel 2 years ago

Answers (1)

Posted by: JasonEgg 2 years ago
Red Belt

I think flip's answer in the comments is best. In Advanced Search, you can use the comparison "matches REGEX" and use ".{5}ABC" which means "any five non-line-break characters and then the string 'ABC'"

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ