Power Query - Use betwen delimiter only if entire column has it

[MasterBash]

Hi,

So I want to use a delimiter to pull what is between parenthesis (). However, the condition of using the delimiter is that the entire column (all the rows in that column) must have the rounded brackets.

Name :	Expected result :
This is a (product) name	product
Here is (another product) name	another product
I am (giving a third) example	giving a third
This is the fourth (example)	example

However, if all rows do not have the delimiter, then do not use the delimiter :

Name :	Expected result :
This is a product name	This is a product name
This is (another product) name	This is (another product) name
I am (giving a third) example	I am (giving a third) example
This is the fourth example	This is the fourth example

How can I accomplish that ?

Thank you.

 

[JEC]

Try

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    result = Table.TransformColumns(Source, {"Name", each if Table.RowCount(Source) = List.Count(List.Select(Source[Name], (x)=> Text.Contains(x,"(") and Text.Contains(x,")"))) then Text.BetweenDelimiters(_,"(",")") else _})  
in
    result

 

[MasterBash]

Thank you ! It works perfectly.

 

[JEC]

Great, cheers!