In powerbi, I would suggest you create a calculated column or measure.
You can use the MID function to return the specific character and manually review.
Please check this official document.
You can also try "split" feature in query editor as below:
Community Support Team _ Eason