How to extract letters and digits in string in Power Query

[leopoldvili_1]

Hi, 

I would like to extract text from the input string and get the result provided in the output by using Power Query.

input:

hello bd AD-001234 hb

this is AD-3245

output:

AD-001234

AD-3245

Can anyone give me some tips? not using R?

Thank you

[leopoldvili_1]

Thank you! @PhilipTreacy  it works!

[Ashish_Mathur]

Hi,

What is basis of extraction?  Everthing from AD till the next space?  Please clarify.

[PhilipTreacy · Accepted solution]

Hi @leopoldvili_1 

Download example PBIX file

Create a Custom Column with this code

List.Select(Text.Split([input]," "), each Text.Contains( _ , "-")){0}

regards

Phil

[Earl40]

Any way to add an if statement where if another column has a certain value then apply the extraction