Forum Discussion
Solved
Using Power Query to extract the first occurring number from a string (URL)
I have a coumn with URLs from which I would like to extract the first occuring number. My constraints: the numbers don't occurre at the same position there might be some numbers further in the str...
Text.Combine(List.FirstN( List.Select( Text.Split(Text.Select( [Column1],{"0".."9","/"}),"/"),(x)=>x<>""),1))
post an example and the desired result