Forum Discussion

LinLinB's avatar
LinLinB
Advocate I
3 years ago
Solved

Mobile Numbers = Not Starting with 0

Hi - my data has no initial data validation so I have to do it all from scratch. With my Mobile number as data type Text (like this 012345678, no gaps), I have these steps which work well:   1...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi LinLinB ,
    you could use a filter that transforms to number and filters those > than 99999999

    Table.SelectRows(#"Added Custom", each Number.From([Column1]) > 99999999)

     See also file attached.

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi LinLinB ,
you could use a filter that transforms to number and filters those > than 99999999

Table.SelectRows(#"Added Custom", each Number.From([Column1]) > 99999999)

 See also file attached.