Forum Discussion

macemit's avatar
macemit
Frequent Visitor
7 years ago
Solved

Text Length filter

Hi,

 

Trying to create what should be an easy filter based on length of a text entry (I need to keep those with 13 characters):

 

#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each Text.Length([Serial_Number__c] = 13))

Can someone help?

 

Thanks.

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion

    Move the bracket.

    Text.Length([Serial_Number__c]) =