Forum Discussion
Extracting a Specific string format from a string of text
Good Day Everyone, I am trying to extract a specific format of: ##a# or (number)(number)(letter)(number) I need first 4 parts of the serial number. I've attached examples of source data and w...
Hi agc1234 ,
In Power BI, when we want to process complex and unordered data, adding many steps using power query may not get the desired results. As we know, power query cannot use regular expressions. If we call Python script and use regular expressions to process the data this time, it will become simple. Please refer to
Using regular expressions in power bi desktop - Microsoft Fabric Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.