Forum Discussion
Solved
Pulling all 10-digit from 1 Cell
Hello All, Need help in extracting 10 digit strings from one cell. Scope is an exported email box and needing to extract all 10-digit numbers from the Subject of the email(is collected within...
=List.Select(Text.SplitAny([Contents],Text.Remove([Contents],{"0".."9"})),each Text.Length(_)=10)
wdx223_Daniel
Community Champion
Community Champion=List.Select(Text.SplitAny([Contents],Text.Remove([Contents],{"0".."9"})),each Text.Length(_)=10)
Thank you very much! This works great, now from this point I should be able to extract each record in the list into a new row in the report!
