Good morning,
.msg files are not as nicely structured as one might expect. And one of the issues you might experience with the loading of the data is the fact that lines from the email body might look like header data, and start with From:, To:, Date:, Subject:, Reply-To:, etc,
Anyhow, you could start of with this simple script and try to add extra layers of filtering on top of the first step:
// The first statement should create a table with three fields named @1, @2 and @3
_tmp:
LOAD *
From (txt, codepage is 1252, no labels, delimiter is '\t', msq, no eof);
// Here we filter out fields that are unrelated tp those we want to keep
_tmp2:
LOAD Subfield(@1, ': ', 1) as Header, Subfield(@1, ': ', 2) as Info
Resident _tmp
Where WildMatch(@1, 'From: *', 'To: *', 'Date: *', 'Subject: *');
DROP Table _tmp;
THis works fine with one message. If you have several, it would be best to wrap this up in a DoDir (you can find this in the QlikView help) where you could assign a incremental number to each message read. Then, using the CrossTable instruction, you could have your self a nice table with the appropriate fields ready for analysis.
Hope this guides you in the appropriate direction,
Regards,
Philippe
