Forum Discussion
Need to split the email subject
Hi,
I need help in removing certian text from the email subject which is captured
Example are : RE: , Fwd: , FW: , Fw:
And get a count of it how many times the same subjected email has been going on.
Thanks !
3 Replies
You can simply use the AI feature in Power BI to do this or use the delimiter in power query. Under Transform Tab select Split column and choose split by Colon.
Split column using AI Feature in Power BI | Column from Example | MiTutorials - YouTube
Hi Thank you for the suggestion.
But if i use it ":" as delimiter if any subject cotains : colon then it's gonna remove that we well and I don't want that to happen.
Select Left Most delimiter and not Each occurence of the delimiter.
