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)
v-jingzhang
Community Support
Community SupportHi MikeD1314
If I understand your requirement correctly, you just need to remove {0} from the end of your previous code. This will give you the complete list rather than only the first item in the list.
= List.Select(List.Transform(Text.Split([TextColumn], " "), each Text.Select(_, {"0".."9"})), each Text.Length(_) = 10)Click the Expand icon on column header of the custom column and select "Expand to New Rows" option.
You will get below result then. Is this what you are after?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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