1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
| <?php
|
| namespace PhpOffice\PhpSpreadsheet\Calculation\Internal;
|
| class WildcardMatch
| {
| private const SEARCH_SET = [
| '~~', // convert double tilde to unprintable value
| '~\\*', // convert tilde backslash asterisk to [*] (matches literal asterisk in regexp)
| '\\*', // convert backslash asterisk to .* (matches string of any length in regexp)
| '~\\?', // convert tilde backslash question to [?] (matches literal question mark in regexp)
| '\\?', // convert backslash question to . (matches one character in regexp)
| "\x1c", // convert original double tilde to single tilde
| ];
|
| private const REPLACEMENT_SET = [
| "\x1c",
| '[*]',
| '.*',
| '[?]',
| '.',
| '~',
| ];
|
| public static function wildcard(string $wildcard): string
| {
| // Preg Escape the wildcard, but protecting the Excel * and ? search characters
| return str_replace(self::SEARCH_SET, self::REPLACEMENT_SET, preg_quote($wildcard, '/'));
| }
|
| public static function compare(?string $value, string $wildcard): bool
| {
| if ($value === '' || $value === null) {
| return false;
| }
|
| return (bool) preg_match("/^{$wildcard}\$/mui", $value);
| }
| }
|
|
