Hi,
I have certain mail subjects which are part static part dynamic for e.g. Job ABC_DEF_GHJ:12345 Here the subject preceding the : is fixed, while the one after is dynamic.
In a day I will have 100's of such mail subjects, some of them will have common fixed parts, only the dynamic vary, But the actions on these mails with the same fixed part is common.
[TABLE="width: 443"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Mail subject[/TD]
[TD]Substring[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12345[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12346[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12347[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12348[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12349[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45678[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45679[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45680[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45681[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
</tbody>[/TABLE]
So in essence if I create an Excel database containing Substring and action I will have something like below
Substring Action
[TABLE="width: 443"]
<tbody>[TR]
[TD]ABC_DEF_GHJ Reply
RST_UVW_XYZ Forward
Now assuming I have all the mail subjects with me in an excel, how can I compare it against the Excel database that I created above to get the action against it.
Please suggest.
Best Regards
Shailesh
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have certain mail subjects which are part static part dynamic for e.g. Job ABC_DEF_GHJ:12345 Here the subject preceding the : is fixed, while the one after is dynamic.
In a day I will have 100's of such mail subjects, some of them will have common fixed parts, only the dynamic vary, But the actions on these mails with the same fixed part is common.
[TABLE="width: 443"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Mail subject[/TD]
[TD]Substring[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12345[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12346[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12347[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12348[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]ABC_DEF_GHJ:12349[/TD]
[TD]ABC_DEF_GHJ[/TD]
[TD]Reply[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45678[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45679[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45680[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]RST_UVW_XYZ:45681[/TD]
[TD]RST_UVW_XYZ[/TD]
[TD]Forward[/TD]
[/TR]
</tbody>[/TABLE]
So in essence if I create an Excel database containing Substring and action I will have something like below
Substring Action
[TABLE="width: 443"]
<tbody>[TR]
[TD]ABC_DEF_GHJ Reply
RST_UVW_XYZ Forward
Now assuming I have all the mail subjects with me in an excel, how can I compare it against the Excel database that I created above to get the action against it.
Please suggest.
Best Regards
Shailesh
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]