Need to split the email subject

[ganeshnr073]

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 !

[miTutorials]

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 

[ganeshnr073]

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.

[miTutorials]

Select Left Most delimiter and not Each occurence of the delimiter.