<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:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place" /><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street" /><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region" /><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PostalCode" /><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City" /><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="address" /><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]--><style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Thanks, that worked.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Regards,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Jim<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p>
<div>
<p class="MsoNormal"><strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:navy">Jim Laurenson</span></font></b></strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy;font-weight:bold"><br>
</span></font></b><font size="2" color="gray" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">Application Analyst<br>
</span></font><strong><b><font size="2" color="navy" face="Verdana"><span lang="EN-US" style="font-size:10.0pt;font-family:Verdana;color:navy">mfi</span></font></b></strong><strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy">
Retail Ltd</span></font></b></strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy;font-weight:bold"><br>
</span></font></b><font size="2" color="gray" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">+44 208 913 5246<br>
+44 7952 676922<br>
</span></font><font size="2" color="silver" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:silver"><a href="mailto:james.laurenson@mfi.co.uk" title="mailto:neil.heffernan@mfi.co.uk">james.laurenson@mfi.co.uk</a></span></font><o:p></o:p></p>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt">
<hr size="2" width="100%" align="center" tabindex="-1">
</span></font></div>
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma"> Hurworth,
Erik [mailto:Erik.Hurworth@cognos.com] <br>
<b><span style="font-weight:bold">Sent:</span></b> 12 February 2008 16:07<br>
<b><span style="font-weight:bold">To:</span></b> LAURENSON, James; powerh-l@lists.sowder.com<br>
<b><span style="font-weight:bold">Subject:</span></b> RE: QTP tab delimited file query.</span></font><span lang="EN-US"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:blue">Hi Jim,</span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:blue">global temporary i_tab integer size 1 byte initial 9 ; where 9 is the ascii value for a TAB<br>
globel temporary gt_tab character*1 initial character(i_tab)</span></font><o:p></o:p></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> <o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:blue">Wherever you need to insert a tab character, use the gt_tab variable,</span></font><o:p></o:p></p>
<!-- Converted from text/rtf format -->
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">Regards</span></font>
<o:p></o:p></p>
<p><font size="2" color="black" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:black">Erik
</span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt">
<hr size="2" width="100%" align="center" tabindex="-1">
</span></font></div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma">
powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com [mailto:powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com]
<b><span style="font-weight:bold">On Behalf Of </span></b>LAURENSON, James<br>
<b><span style="font-weight:bold">Sent:</span></b> 12 February 2008 16:00<br>
<b><span style="font-weight:bold">To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style="font-weight:bold">Subject:</span></b> QTP tab delimited file query.</span></font><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Hi,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Does anyone know of a simple way of embedding tabs into a portable subfile in QTP?<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Regards,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:navy">Jim Laurenson</span></font></b></strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy;font-weight:bold"><br>
</span></font></b><font size="2" color="gray" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">Application Analyst<br>
</span></font><strong><b><font size="2" color="navy" face="Verdana"><span lang="EN-US" style="font-size:10.0pt;font-family:Verdana;color:navy">mfi</span></font></b></strong><strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy">
Retail Ltd</span></font></b></strong><b><font size="2" color="navy" face="Arial"><span lang="EN-US" style="font-size:10.0pt;
font-family:Arial;color:navy;font-weight:bold"><br>
</span></font></b><font size="2" color="gray" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:gray">+44 208 913 5246<br>
+44 7952 676922<br>
</span></font><font size="2" color="silver" face="Arial"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:silver"><a href="mailto:james.laurenson@mfi.co.uk" title="mailto:neil.heffernan@mfi.co.uk">james.laurenson@mfi.co.uk</a></span></font><u1:p></u1:p><o:p></o:p></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><u1:p> </u1:p><o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="2" width="100%" align="center">
</span></font></div>
<p class="MsoNormal"><font size="1" color="gray" face="Arial"><span style="font-size:
7.5pt;font-family:Arial;color:gray">The information in this e-mail is confidential and is intended solely for the use of the individual or entity to which it is addressed.
Any views or opinions presented are those of the author and do not necessarily represent those of MFI Retail Ltd or its associated companies.<br>
<br>
This e-mail is issued by MFI Retail Limited, whose registered office is situated at<br>
Southon House, 333 The Hyde, <st1:address w:st="on"><st1:Street w:st="on">Edgware Road</st1:Street>,
<st1:City w:st="on">London</st1:City> <st1:PostalCode w:st="on">NW9 6TD</st1:PostalCode>
<st1:country-region w:st="on">United Kingdom</st1:country-region></st1:address>, registered number 05799087 (<st1:country-region w:st="on">England</st1:country-region> and
<st1:country-region w:st="on"><st1:place w:st="on">Wales</st1:place></st1:country-region>).</span></font><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not
use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
<o:p></o:p></span></font></p>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="-2">The information in this e-mail is confidential and is intended solely for the use of the individual or entity to which it is addressed. Any views or opinions presented are those of the author and do not necessarily
represent those of MFI Retail Ltd or its associated companies.<br>
<br>
This e-mail is issued by MFI Retail Limited, whose registered office is situated at<br>
Southon House, 333 The Hyde, Edgware Road, London NW9 6TD United Kingdom, registered number 05799087 (England and Wales).<br>
</font>
</body>
</html>