Urgent Help needed!!.. again same problem. exporting Data fromtxt toSubfile

[Joe Boyle]

You might have to try this with a portable subfile as in 'subfile inp-file
portable include t-cust-no, t-order-no, t-part-no', as permanent subfiles
have been known to record wrap.

 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Guy Werry
Sent: 08 March 2007 16:34
To: powerh-l at lists.sowder.com
Subject: RE: Urgent Help needed!!.. again same problem. exporting Data
fromtxt toSubfile

 

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/8c4c05e8/attachment-0001.html