Remove string and parenthesis

[AMCMILLAN]

Hi,

 I have a column with a number of different stores each ending with the area (these are different) in parenthesis.

 What I would like is to remove the parenthesis and the string within that.

 eg. Store 1 (Cardiff) = Store 1
       Store 2 (Birmingham) = Store 2

etc

Any ideas how to do this?
Thanks

Alex

[KarinSzilagyi]

Hi @AMCMILLAN, there are two options to achieve this, depending on whether you want to cleanse it as a column in Power Query or extract it via DAX.

Power Query Editor:

• Transform > Extract > Text Before Delimiter
• Set the delimiter to " (" => this will keep the first part of your text until it encounters a space + parenthesis (works if the text you want to keep is always before the parenthesis:
  

DAX (Note: I renamed the table + column in this example, to make it easier to understand the formula):

Cleaned DAX = LEFT(ExampleTable[RawColumn], SEARCH(" (", ExampleTable[RawColumn])-1)

[amitchandak · Accepted solution]

@AMCMILLAN , Power Query -> Transform ->Extract -> Text before Delimiter 

https://youtu.be/oGY4RoPKDOE

Dax 
New column = Left([Column], Search("(", [Column],,0)) )

[AMCMILLAN]

Thank-you, I sent the request and then realised what I needed to do but thank-you for posting a reply.