MQSeries.net :: View topic

sathish.mani · Posted: Fri Jun 19, 2015 11:05 am Post subject:

I am receiving an email at the email input node and i need to scan through the body of email and put some of those contents to the database.

CAST(InputRoot.MIME.Data.BLOB.BLOB AS CHARACTER ENCODING MQENC_INTEGER_NORMAL)

The above command casts the blob content of the email body to a string. The string is an html string and I dont know how to convert it to a plain text and get the contents of the body. When i send an email with email body as "hello world", the above command results in below html string.

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello world<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>

Is there any way in message broker to parse the html file or convert it to plain text and the contents from it (hello world from above html string)??

I am new to message broker and I would appreciate any help