Forum Discussion
Solved
Remove semi colon only when inside parentheses
I have data that contains multiple values within a single cell. I am attempting to separate this data, but occasionally there are additional semi colons throughout these values that are not delimiter...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
if there is only a semicolon inside the parentheses then it is simple.
show an example so we can help you