Replace/Remove everything between brackets (plus brackets)

[Jqarga]

Hello guys,

Is there something similar to replace (*) in Power Query?

I need to accomplish the following:

Many thanks,

J

 

[anvg]

Hi,
Let's try

Text.Combine(Table.SelectRows(Table.TransformColumns(Table.AddIndexColumn(Table.FromColumns({Text.SplitAny("dog(IP1234);cat(IP123);tiger(IP5286)", "()")}),"id"),{"id",each Number.Mod(_,2)}),each [id]=0)[Column1],"")

Regards,