Extracting an variable alphanumeric ID out of a text

[HILGARTH]

How to extract out of “Column Description” the alphanumeric ID that always starts with the letter P and is followed by 7 digits and put it in a separate column?

Column Description

Charles has engaged on Project P5671223 with Peter

with P8702345 the delivery succeeds to saint Paul and Mary

together with others P9906123 was a success

William and John knew about P8765439

Paul and Peter as well as Anne like the breeze P9908765 brings

[Jayaselvan]

New Column =
VAR _Description = Table[Column Description]
VAR _Pattern = "P\d{7}"
VAR _Match = REGEXMATCH(Table[Column Description], "P\d{7}")
VAR _ExtractedID = IF(_Match, REGEXEXTRACT(_Description, _Pattern), BLANK())
RETURN _ExtractedID

[HILGARTH]

Thx for this proposal - took me a second to find out that this is R 🙂

[Etero · Accepted solution]

I couldn't do it with DAX, but if M code is okay then

= Text.Middle(Text.Select([Column Description], {"0".."9"}), Text.PositionOf(Text.Select([Column Description], {"P", "0".."9"}), "P")

[HILGARTH]

nice - quick & easy done.