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}?
=List.Select(Text.SplitAny([YourColumnName],Text.Remove([YourColumnName],{"0".."9"})),each Text.StartsWith(_,"5001") and Text.Length(_)=10){0}?
I have a similar request however I need to find the ILXXX within the text sting
Works North Project MP2 IL207 Concrete Pour
Works South Project SP1 IL315 Light Fitting
Works West Project IL216 Room Painting
The result would be another column with the IL207, IL315 and IL216