<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>In
qtp, define an empty subfile:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007>qtp</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
acc dictionaryfile (any file in your current dictionary)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
set input limit 1</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
set process limit 1</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
temp t-cust-no zoned unsigned size
9</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
temp t-order-no char * 5</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
temp t-part-no char *
7</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
temp
t-fill char *
1</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
sub inp-file keep incl t-cust-no, t-fill, t-order-no, t-fill,
t-part-no</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
go</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
exit</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>On
HP-UX (note here for you, Vamsi, it is REALLY helpful to know what your platform
/ version is!) this will result in two files:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007> inp-file.sf - the actual data file
of the subfile, which will be EMPTY</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007> inp-file.sfd - the subfile
DEFINITION file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>What
you would then do is take your text file that you are trying to input and rename
it to be "inp-file.sf".</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>NOTE:
depending upon what platform you are on, you will probably have some record
length issues - on Unix you certainly could, but you can use utility programs to
get everything to a common size.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>Then,
to process against your dictionary, you could do:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007>qtp</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>>
acc *inp-file link t-cust-no to cust-no of whatever </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>then,
perform your data massaging ... you'll have to play with the part number a bit
in order to do the RJ and space filling.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007>Hopefully that helps, keep us
posted.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335512616-08032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=335512616-08032007>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf Of
</B>vamsi krishna<BR><B>Sent:</B> Thursday, March 08, 2007 10:09
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Urgent Help
needed!!.. again same problem. exporting Data from txt
toSubfile<BR><BR></FONT></DIV>Guys,<BR><BR>I tried my best to do this.. but
failed..<BR><BR>Please find the attached text file.<BR><BR>Here's what i need
to do..<BR><BR>There are three items in the text file:<BR><BR>1st:Customer
number<BR>2nd: Order Number <BR>3rd: Part Number<BR><BR>In the powerhouse
dictionary, <BR>Customer number's size is 9<BR>order number's size is
20<BR>Part Number's size is 12 (right Justified with spaces)<BR><BR>In the
attached file:<BR>Customer number's size is 9<BR>order number's size is
5<BR>Part Number's size is 7 or 6 ( no proper justification)<BR><BR>Now i need
a subfile which will contain all the three items, and I should be able to link
them with dictionary file (that means subfile should contain index consisting
of all three items) <BR><BR>Please if anyone can send me the detailed process
to deal with this, that would be really grateful.<BR clear=all><BR>Let me know
if you have any queries.<BR><BR>Thanks and Regards,<BR>Vamsi<BR><BR>--
<BR>"Nothing is impossible as impossible itself says i m possible"
</BLOCKQUOTE>The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</BODY></HTML>