I have a excel column from which I need to extract XYZ12345671, XYZ12389782 and XYZ12389893 which can occur anywhere in the column like below:
How can I accomplish this using Power Query. I want to extract it to a new column. The pattern is XYZ followed by 8 numbers
Go to Solution.
= Table.AddColumn(PriorStepOrTableName, "ID", each Text.Range([Details], Text.PositionOf([Details], "XYZ"), 11))
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.