There are two types of wildcard (pattern matching) systems used in Opus.
Standard pattern matching syntax is a simple wildcard system - if you're familiar with typing *.doc to mean all document files, you should start with this.
Regular expressions are a more powerful but also more complicated system that let you match much more complex patterns. They also let you perform search and replace operations, which lets you perform complex batch renames via the Advanced Rename function.