[Summary view]

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