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}?
Many thanks for the reply 🙂
OxO compan Inc. - PO 4500806733/280
or
Xyz Limtd. - PO 4500806733_10
My column has such text in the above. I tried manipulating the characted in your formula from {10} to {13}, but unfortuantely it's not reading the numbers after the "/" or "_". Any recommendation?
What should be the output of 2 examples you've provided?
Ideally, to read the "/280" or "_10" after the 10 digits. "45xxxxxxxx"
Or to read eaverything until it finds space " ". That's where I know the Purchase Order is complete 🙂