Forum Discussion
leopoldvili_1
Helper I
Helper IHow to extract letters and digits in string in Power Query
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-324...
Create a Custom Column with this code
List.Select(Text.Split([input]," "), each Text.Contains( _ , "-")){0}regards
Phil
PhilipTreacy
Super User
Super User
Create a Custom Column with this code
List.Select(Text.Split([input]," "), each Text.Contains( _ , "-")){0}
regards
Phil
Earl40Helper I
Helper IAny way to add an if statement where if another column has a certain value then apply the extraction