Extracting Emails with Power Query Using JavaScript and Regex in Web.Page Function
In this video, I demonstrate how to use JavaScript code within the Web.Page function in Power Query to leverage Regex for extracting email addresses from text data. Learn how to integrate JavaScript with Power Query for advanced data transformation tasks, making your data processing more efficient and powerful. This step-by-step guide is perfect for those looking to enhance their data analysis skills using Power Query and Regex.
00:00 How to use Java Script in Power Query
03:00 Use RegExp in Java script
05:00 Create a custom function for extracting email
06:30 solve the problem