Forum Discussion
markefrody
Post Patron
7 years agoRemoving 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
- idrabbleFrequent Visitor
Place this into a new column and change the TableName & ColumnName to suit
Remove Parenthesis = SUBSTITUTE (
SUBSTITUTE ( 'TableName'[Column Name], "(", "" ),
")",
"")Ian
- markefrody
Post Patron
Thanks idrabble (Ian). It works!