Filter rows based on length in Power Query

[Jendoren]

Hello all! 

I am working with a table that has phone numbers of varying lengths in a column called dialednumber as part of the table ytd_cb. 

What I want is a query that will filter the table to only show phone numbers that are 11 digits in length.

Thank you! 

[lpetty421]

Thanks Jakinta!!!

[m_dekorte]

Hi @Jendoren,

Give this a go. Set a manual filter on that column in your table, this is just to create the bulk of the syntax.

Next inside the formula bar update the code as highlighted here:

Please mark this answer as solution when it helped you to resolve your question, thanks!

[Jakinta]

Try the step below.

Table.SelectRows(YourPreviousStepName, each Text.Length([dialednumber])=11)