cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markefrody Member
Member

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

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
idrabble Frequent Visitor
Frequent Visitor

Re: Removing Open and Close Parenthesis in Text

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

 

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

 

Ian

2 REPLIES 2
idrabble Frequent Visitor
Frequent Visitor

Re: Removing Open and Close Parenthesis in Text

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

 

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

 

Ian

markefrody Member
Member

Re: Removing Open and Close Parenthesis in Text

Thanks @idrabble (Ian). It works! 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 75 members 1,219 guests
Please welcome our newest community members: