116.1 - regex via pandas, Extract first match
Power Query doesn't have a regex function. It does have a python (and R) function. We can leverage python's regex library inside Power Query.
Unfortunately you can't use python or R in Excel. For whatever reason.
In the next video I'll show how to extract all matches, instead of only the first.
You need to install python (python.org) and the pandas & numpy library.
You do this by opening the command prompt (press Windows+R), type "cmd" and press enter. Then write
pip install pandas
and hit enter. Wait until it installs. Afterwards write
pip install numpy
and press enter.
00:00 Python.Execute
00:37 Pure python
03:38 Going through Python.Execute
04:10 Create a Power Query function
07:22 Call the function