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.
In Power query replace ";" with ,
See screen print
I am an unpaid volunteer helper seeking kudos.
Please show your thanks by clicking the Accept Solution button and the thumbs up button to leave kudos.
Thanks