Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.


1 comment
Date Votes
  • Sure. What you are looking at is a regular expression.

    microsoft office(?!.*viewer)(?!.*web components)(?!.*project)(?!.*visio)(?!.*sharepoint)(?!.*validation)

    Using the Matches Expression comparison the string above basically says:

    Show me computers that have an application that contains the words "microsoft office" but it can't have the words "viewer" or "project", etc in the name. the "?!." are special characters which are known as a negative look ahead.

    For instance, there are computers that only have Microsoft Office Word Viewer installed but don't actually have Microsoft Office. If we didn't remove the word viewer then you could get some bad data.

    There are a lot of Regular Expression books and tutorials online. Here is a decent one.