How to remove rows based on text length

[max_mustermann]

I want to delete all rows of Column "test" which contain less than 4 characters.

E.g. "132" should be removed, "testtest" should not be removed.

I have tried the following in M but there is a syntax error:

= if Text.Length([test]) <4 then Table.RemoveRows(Table.FromRecords,1)

[mahenkj2 · Accepted solution]

Hi @max_mustermann ,

I can just tell you alternate way, since you are already checking Text.Length, just filtering records <4 or >3 will serve the purpose:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ2UorViVYqSS0uAWGl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [test = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"test", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Test-Length", each Text.Length([test])),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Test-Length", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each [#"Test-Length"] > 3)
in
    #"Filtered Rows"