Search notes:

Power Query: Use Web.Page to execute JavaScript to match Regular Expressions

let
   findPattern=(txt, pattern) => Web.Page(
      "<script>
          var re = /" & pattern & "/;
          document.write('" & txt & "'.match(re));
      </script>")[Data]
      {0}[Children]
      {0}[Children]
      {1}[Text]
      {0}
in
   findPattern("hello 42 world", "\d+")

See also

Evaluating JavaScript with Power Query's Web.Page function.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1759407971, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Power-Query/M-formula/standard-library/Web/Page/script/regular-expression(46): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78