Forum Discussion

MikeD1314's avatar
MikeD1314
Regular Visitor
3 years ago
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...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    =List.Select(Text.SplitAny([Contents],Text.Remove([Contents],{"0".."9"})),each Text.Length(_)=10)

Einomi's avatar
Einomi
Icon for Helper V rankHelper V
3 years ago

Hi MikeD1314 

 

Welcome to this wonderful Power BI community.

 

Just giving you a tip, if you want your posts to be answered. Post examples of your data and examples of what you expect as a outcome.

 

Pics are welcome.

 

Hope it helps