Urgent Help needed!!.. again same problem. exporting Data from txt toSubfile

[Guy Werry]

In qtp, define an empty subfile:
 
qtp
> acc dictionaryfile (any file in your current dictionary)
> set input limit 1
> set process limit 1
> temp    t-cust-no    zoned unsigned size 9
> temp    t-order-no    char * 5
> temp    t-part-no    char * 7
> temp    t-fill            char * 1
> sub inp-file keep incl t-cust-no, t-fill, t-order-no, t-fill, t-part-no
> go
> exit
 
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:
    inp-file.sf - the actual data file of the subfile, which will be EMPTY
    inp-file.sfd - the subfile DEFINITION file.
 
What you would then do is take your text file that you are trying to input and rename it to be "inp-file.sf".
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.
 
Then, to process against your dictionary, you could do:
 
qtp
> acc *inp-file link t-cust-no to cust-no of whatever 
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.
 
Hopefully that helps, keep us posted.
 
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com [mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of vamsi krishna
Sent: Thursday, March 08, 2007 10:09 AM
To: powerh-l at lists.sowder.com
Subject: Urgent Help needed!!.. again same problem. exporting Data from txt toSubfile


Guys,

I tried my best to do this.. but failed..

Please find the attached text file.

Here's what i need to do..

There are three items in the text file:

1st:Customer number
2nd: Order Number 
3rd: Part Number

In the powerhouse dictionary, 
Customer number's size is 9
order number's size is 20
Part Number's size is 12 (right Justified with spaces)

In the attached file:
Customer number's size is 9
order number's size is 5
Part Number's size is 7 or 6 ( no proper justification)

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) 

Please if anyone can send me the detailed process to deal with this, that would be really grateful.

Let me know if you have any queries.

Thanks and Regards,
Vamsi

-- 
"Nothing is impossible as impossible itself says i m possible" 


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070308/cb5e079f/attachment.html