Forum Discussion
Find Text (Number) in text string (Beginning with) and return it in Custom Column
Hi, I have been searching high and low for an answer to this and so far can't find anything. Within Power Query I have a column that I want it to find text (a number) that begins with the sam...
=List.Select(Text.SplitAny([YourColumnName],Text.Remove([YourColumnName],{"0".."9"})),each Text.StartsWith(_,"5001") and Text.Length(_)=10){0}?
