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