Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Remove string and parenthesis

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.  ...
Need Help
  • amitchandak's avatar
    amitchandak
    8 months ago

    Anonymous , Power Query -> Transform ->Extract -> Text before Delimiter 


    https://youtu.be/oGY4RoPKDOE

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

amitchandak's avatar
amitchandak
Super User
8 months ago

Anonymous , Power Query -> Transform ->Extract -> Text before Delimiter 


https://youtu.be/oGY4RoPKDOE

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 months ago

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