In
software
Software consists of computer programs that instruct the Execution (computing), execution of a computer. Software also includes design documents and specifications.
The history of software is closely tied to the development of digital comput ...
, a wildcard character is a kind of placeholder represented by a single
character, such as an
asterisk
The asterisk ( ), from Late Latin , from Ancient Greek , , "little star", is a Typography, typographical symbol. It is so called because it resembles a conventional image of a star (heraldry), heraldic star.
Computer scientists and Mathematici ...
(), which can be interpreted as a number of literal characters or an
empty string
In formal language theory, the empty string, or empty word, is the unique String (computer science), string of length zero.
Formal theory
Formally, a string is a finite, ordered sequence of character (symbol), characters such as letters, digits ...
. It is often used in file searches so the full name need not be typed.
Telecommunication
In
telecommunications
Telecommunication, often used in its plural form or abbreviated as telecom, is the transmission of information over a distance using electronic means, typically through cables, radio waves, or other communication technologies. These means of ...
, a wildcard is a character that may be substituted for any of a defined subset of all possible characters.
* In
high-frequency (HF)
radio
Radio is the technology of communicating using radio waves. Radio waves are electromagnetic waves of frequency between 3 hertz (Hz) and 300 gigahertz (GHz). They are generated by an electronic device called a transmitter connec ...
automatic link establishment, the wildcard character may be substituted for any one of the 36 upper-case
alphanumeric
Alphanumericals or alphanumeric characters are any collection of number characters and letters in a certain language. Sometimes such characters may be mistaken one for the other.
Merriam-Webster suggests that the term "alphanumeric" may often ...
characters.
* Whether the wildcard character represents a single character or a
string of characters must be specified.
Computing
In
computer
A computer is a machine that can be Computer programming, programmed to automatically Execution (computing), carry out sequences of arithmetic or logical operations (''computation''). Modern digital electronic computers can perform generic set ...
(
software
Software consists of computer programs that instruct the Execution (computing), execution of a computer. Software also includes design documents and specifications.
The history of software is closely tied to the development of digital comput ...
) technology, a wildcard is a symbol used to replace or represent zero or more characters.
Algorithms for matching wildcards have been developed in a number of
recursive and non-recursive varieties.
File and directory patterns
When specifying file names (or paths) in
CP/M,
DOS,
Microsoft Windows
Windows is a Product lining, product line of Proprietary software, proprietary graphical user interface, graphical operating systems developed and marketed by Microsoft. It is grouped into families and subfamilies that cater to particular sec ...
, and
Unix-like
A Unix-like (sometimes referred to as UN*X, *nix or *NIX) operating system is one that behaves in a manner similar to a Unix system, although not necessarily conforming to or being certified to any version of the Single UNIX Specification. A Uni ...
operating system
An operating system (OS) is system software that manages computer hardware and software resources, and provides common daemon (computing), services for computer programs.
Time-sharing operating systems scheduler (computing), schedule tasks for ...
s, the
asterisk
The asterisk ( ), from Late Latin , from Ancient Greek , , "little star", is a Typography, typographical symbol. It is so called because it resembles a conventional image of a star (heraldry), heraldic star.
Computer scientists and Mathematici ...
character (, also called "star") matches zero or more characters. For example, matches and but not . If files are named with a date stamp, wildcards can be used to match date ranges, such as
*.mp4
to select video recordings from , to facilitate file operations such as copying and moving.
In Unix-like and DOS operating systems, the
question mark
The question mark (also known as interrogation point, query, or eroteme in journalism) is a punctuation, punctuation mark that indicates a question or interrogative clause or phrase in many languages.
History
The history of the question mark is ...
matches exactly one character. In DOS, if the question mark is placed at the end of the word, it will also match missing (zero) trailing characters; for example, the pattern will match and , but not .
In
Unix shell
A Unix shell is a Command-line_interface#Command-line_interpreter, command-line interpreter or shell (computing), shell that provides a command line user interface for Unix-like operating systems. The shell is both an interactive command languag ...
s and
Windows PowerShell, ranges of characters enclosed in
square brackets ( and ) match a single character within the set; for example, matches any single uppercase or lowercase letter. In Unix shells, a leading exclamation mark negates the set and matches only a character not within the list. In shells that interpret as a history substitution, a leading caret can be used instead.
The operation of matching of wildcard patterns to multiple file or path names is referred to as
''globbing''.
Databases
In
SQL, wildcard characters can be used in LIKE expressions; the
percent sign matches zero or more characters, and
underscore
An underscore or underline is a line drawn under a segment of text. In proofreading, underscoring is a convention that says "set this text in italic type", traditionally used on manuscript or typescript as an instruction to the printer. Its ...
a single character.
Transact-SQL also supports
square brackets ( and ) to list sets and ranges of characters to match, a leading caret negates the set and matches only a character not within the list. In
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational database, relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsof ...
, the
asterisk
The asterisk ( ), from Late Latin , from Ancient Greek , , "little star", is a Typography, typographical symbol. It is so called because it resembles a conventional image of a star (heraldry), heraldic star.
Computer scientists and Mathematici ...
sign matches zero or more characters, the
question mark
The question mark (also known as interrogation point, query, or eroteme in journalism) is a punctuation, punctuation mark that indicates a question or interrogative clause or phrase in many languages.
History
The history of the question mark is ...
matches a single character, the
number sign
The symbol is known as the number sign, hash, (or in North America) the pound sign. The symbol has historically been used for a wide range of purposes including the designation of an ordinal number and as a Typographic ligature, ligatured abbre ...
matches a single digit (0–9), and square brackets can be used for sets or ranges of characters to match.
Regular expressions
In
regular expression
A regular expression (shortened as regex or regexp), sometimes referred to as rational expression, is a sequence of characters that specifies a match pattern in text. Usually such patterns are used by string-searching algorithms for "find" ...
s, the
period (, also called "dot") is the wildcard pattern which matches any single character. Followed by the
Kleene star
In mathematical logic and theoretical computer science, the Kleene star (or Kleene operator or Kleene closure) is a unary operation on a Set (mathematics), set to generate a set of all finite-length strings that are composed of zero or more repe ...
operator, which is denoted as an
asterisk
The asterisk ( ), from Late Latin , from Ancient Greek , , "little star", is a Typography, typographical symbol. It is so called because it resembles a conventional image of a star (heraldry), heraldic star.
Computer scientists and Mathematici ...
(), we obtain , which will match zero or more arbitrary characters.
See also
*
glob (programming)
*
Pattern matching
*
Query by Example
*
Wild card (cards)
*
Wildcard DNS record
*
wildmat
References
*{{FS1037C MS188
External links
How to Use Wildcards
Computer file formats
Pattern matching