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)

MikeD1314's avatar
MikeD1314
Regular Visitor
3 years ago

Thanks v-jingzhang. I've removed the "{0}" but isnt listing all of the items needed.

This is what I'm trying to get to, but want to learn along the way.

 

 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi MikeD1314 

Can you paste some sample data of the Contents column so I can use it for test?