Outlook Emails exported to excel to be grouped by Subject

lovelikecheese

Hi Rapidminer Community,

I came across the Aggregate function and would like to group by the Subject type. However, I do realise that the group by function works differently from the Group by function in Outlook. 

Take the below email subject type for instance:
Email 1: This is it
Email 2: Re: This is it
Email 3: FW: This is it


In Outlook, the 3 emails above are grouped under 1 subject in Outlook, however, the Aggregate function reads in as 3 different subjects.

Is there any workarounds to this? 


Thank you!

BalazsBaranyRM

Hi!

One way to solve this is using the Replace operator. This will use a regular expression to find the text you're looking for and replace it with the text you specify.

You're looking for characters followed by a colon and whitespace in the beginning of the subject, possibly repeated. A regular expression for this is the following:

^([A-Z][A-Za-z]+: *)*

The replacement in this case would be the empty string (just leave "replace by" empty).

Regards,
Balázs