Forum Discussion
leopoldvili_1
Helper I
3 years agoHow 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...
- 3 years ago
Create a Custom Column with this code
List.Select(Text.Split([input]," "), each Text.Contains( _ , "-")){0}regards
Phil
leopoldvili_1
Helper I
3 years agoThank you! PhilipTreacy it works!