Forum Discussion

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
7 years ago
Solved

Removing Open and Close Parenthesis in Text

Hi,

 

I'm trying to remove both open " ( " and close " ) " parenthesis in a word containing both of them.

 

Example:

(New Message)

 

I want it to be:

New Message

 

I cannot seem to find the correct DAX formula to remove both the open and close parenthesis.

 

Appreciate if you can help me.

 

Thanks!

 

Best regards,

Mark

 

 

 

 

  • Place this into a new column and change the TableName & ColumnName to suit

     

    Remove Parenthesis = SUBSTITUTE (
    SUBSTITUTE ( 'TableName'[Column Name], "(", "" ),
    ")",
    "")

     

    Ian

2 Replies

  • idrabble's avatar
    idrabble
    Frequent Visitor

    Place this into a new column and change the TableName & ColumnName to suit

     

    Remove Parenthesis = SUBSTITUTE (
    SUBSTITUTE ( 'TableName'[Column Name], "(", "" ),
    ")",
    "")

     

    Ian