Filtering out

[amandabus21]

Hello,

Is there a way I can only keep values that have 10 digits?

For example I want to keep only the fields that have 10 digits?

[latimeria · Accepted solution]

Hi @amandabus21 ,

try this:

Table.SelectRows(PreviousStep, each Text.Length([Column1]) > 10 )

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMDI0MLI0MDRQitWB8IHIHIVjYmpmhFuWDhwzAwNzCxjHwMAYwTTEKoqdaUgaMxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Length([Column1]) > 10 )
in
    #"Filtered Rows"

[ND_Pard · Accepted solution]

I like the solution provided above by: latimeria; however, instead of " > 10 ", I think you would want " = 10 ".

Good luck.

[latimeria · Accepted solution]

Hi @amandabus21 ,

try this:

Table.SelectRows(PreviousStep, each Text.Length([Column1]) > 10 )

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMDI0MLI0MDRQitWB8IHIHIVjYmpmhFuWDhwzAwNzCxjHwMAYwTTEKoqdaUgaMxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Length([Column1]) > 10 )
in
    #"Filtered Rows"