Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Delete rows containing string.

Hey guys 🙂 I want to remove rows containing string in power query. Is there any option to solve my problem? 🙂
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    If you are looking to preserve rows that contain numbers only, you can try this.

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkxKNjQyVorViVaC0cYQKrEixdTMXCk2FgA=", 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( Text.Remove([Column1], {"0".."9"} ) ) = 0 )
in
    #"Filtered Rows"

     

    Also, see the attached for the ref.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz  i mean rows e.g. "1234A235" and so on... 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

considers that:

 

Text.Length( Text.Remove("+2345645", {"0".."9"} ))=1

 

try

Value.Type(Value.FromText("+2345645"))

 

or

 

Number.FromText("+2345645")

Number.FromText("+234wa5645")

or

Value.Is(value as any, type as type) as logical

 

 

PS

Could please someone explain me how to do to attach/upload some scriptfile?