This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C157B6.52CDADC0
Content-Type: text/plain;
charset="iso-8859-1"
John,
I'm not surprised that it didn't work as this was NOT the complete script,
only the help text and modification history sections of it. You'll have to
wait until I have finished coding it.
Any offers from people willing to be BETA testers when it's ready?
regards,
Robert
-----Original Message-----
From: John Penney [mailto:JPENNEY@co.pierce.wa.us]
Sent: 17 October 2001 23:47
To: robert.mills@windsong-services.co.uk
Subject: Conversion Script et al
Robert:
Tried your script and got the following:
![s+'R;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;']
^
Variable name encountered, but variable is not defined. (CIERR 9805)
Also perceive same problem with the evaluation of small 'b' in your script.
Any ideas?
Many tks in Advance
Subject: RE: QTP, QUIZ Files with commas.
Perhaps the following work-in-progress command might interest somebody?
echo
![s+'R;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;']
echo ![b+' DEL2SUB - Convert delimited file to PowerHouse Portable
Subfile']
echo
![s+'5;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;']
echo ![b+'']
echo ![b+' Syntax:']
echo ![b+' DEL2SUB ifile[, [ofile][, delim]]']
echo ![b+'']
echo ![b+' Parameters:']
echo ![b+' ifile Name of delimited file.']
echo ![b+' ofile Name to use for TEMPORARY Portable Subfile.']
echo ![b+' delim Field delimiter (default: TAB).']
echo ![b+'']
echo ![b+' Restrictions:']
echo ![b+' Current version only supports TAB (decimal 9) as a
delimiter']
echo ![b+'']
echo ![b+' Additional Notes:']
echo ![b+' In MS-Excel, make sure all the cells are not activated. The']
echo ![b+' best way is to copy the area you want to transfer to a new']
echo ![b+' worksheet (exclude column headings), save the worksheet as']
echo ![b+' Text (Tab delimited)(.txt).']
echo ![b+' Transfer the file to the HP3000 as ASCII. Set host record']
echo ![b+' size to 1000 (so the file won't wrap). Make sure to NOT']
echo ![b+' convert TABs to SPACEs.']
echo ![b+'']
echo
![s+'F;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;']
#
# Author: Robert W.Mills
#
<very large snip to hide very untidy alpha code>
Modification History:
Versn | Date | Who | Reason for Change
------+------------+-----+------------------------------------------
01.00 | dd/mm/2001 | RWM | Initial version. Based on DELIM.QZPRGMS
| | | written by Kim A.Williams (11/08/98).
| | | Now handles any size file but is slower
| | | than original (reads input file twice).
#===================================================================
# End of command file.
#===================================================================
*****************************
Robert W.Mills, Systems Development Manager, Windsong Services
Electron House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND
Tel: +44 (0)1689.870622 x 3005 Fax: +44 (0)1689 899026
robert.mills@windsong-services.co.uk
********************************
The thoughts, comments, and opinions expressed herein are mine.
They do not reflect those of my employer, nor anyone else.
********************************
***Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message.
-----Original Message-----
From: Seamus BROWNE [mailto:Seamus.Browne@partage.org]
Sent: 17 October 2001 14:50
To: powerh-l@lists.swau.edu
Subject: QTP, QUIZ Files with commas.
Hi,
I found your posting on the PH list, concerning the commas within records.
On a HP3000, the awk utility
Someone already suggested in reply to your posting that it would be easier
to do the REPLACE op outside of PH, from within a job.
HP3000 users have access to the Unix ( PosiX ) utility "awk". AWK.HPBIN.SYS.
Awk seems to be the standard for parsing, replacing data in files or
building new files
with reformatted data (using the printf function) .
I have not used it, yet.
The syntax is here <http://vectorsite.tripod.com/tsawk2.html#m2>
http://vectorsite.tripod.com/tsawk2.html#m2
Now if I may widen the debate.
We are having the same kind of comma problem here. Or soon will be, when
we start receiving big files from Internet cgis. (Common gateway interfaces)
Fields in these files are separated by "|" or commas or semi-colons and the
object of the game is to get them into the (Image) database.
Now I think that that is problem that will be facing hundreds of PH users
the
world over.
Introducing a REPLACE function in QTP and QUIZ would certainly increase
efficiency, but in world where file portability is an absolute necessity, it
would
only be a very small step.
What I am looking for is a file conversion utility that would take a file
from the Net,
full of data with separators and transform it into a standard PH subfile.
Or even a PH "portable subfile" (i.e. a data file and a mini-dictionary
file). When
I say a file conversion utility, this could be a job or command file that
calls awk
and/or other stuff but eventually produces a file directly recognisable by
PH
and without the hassle of declaring a file in the dictionary.
Anyone interested in putting this together ?
Seamus.Browne@partage.org
------_=_NextPart_001_01C157B6.52CDADC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
RE: Conversion Script et al
John,
I'm not surprised that it didn't work as this was NOT =
the complete script, only the help text and modification history =
sections of it. You'll have to wait until I have finished coding =
it.
Any offers from people willing to be BETA testers =
when it's ready?
regards,
Robert
-----Original Message-----
From: John Penney [mailto:JPENNEY@co.pierce.wa.us]
Sent: 17 October 2001 23:47
To: robert.mills@windsong-services.co.uk
Subject: Conversion Script et al
Robert:
Tried your script and got the following:
![s+'R;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;=
;;;;;;']
^
Variable name encountered, but variable is not =
defined. (CIERR 9805)
Also perceive same problem with the evaluation of =
small 'b' in your script.
Any ideas?
Many tks in Advance
Subject: RE: =
QTP, QUIZ Files with commas.
Perhaps the following work-in-progress command might =
interest somebody?
echo
![s+'R;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;=
;;;;;;;;']
echo ![b+' DEL2SUB - Convert delimited file =
to PowerHouse Portable
Subfile']
echo
![s+'5;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;=
;;;;;;;;']
echo ![b+'']
echo ![b+' Syntax:']
echo ![b+' DEL2SUB ifile[, =
[ofile][, delim]]']
echo ![b+'']
echo ![b+' Parameters:']
echo ![b+' ifile Name =
of delimited file.']
echo ![b+' ofile Name =
to use for TEMPORARY Portable Subfile.']
echo ![b+' delim =
Field delimiter (default: TAB).']
echo ![b+'']
echo ![b+' Restrictions:']
echo ![b+' Current version only =
supports TAB (decimal 9) as a
delimiter']
echo ![b+'']
echo ![b+' Additional Notes:']
echo ![b+' In MS-Excel, make sure =
all the cells are not activated. The']
echo ![b+' best way is to copy =
the area you want to transfer to a new']
echo ![b+' worksheet (exclude =
column headings), save the worksheet as']
echo ![b+' Text (Tab =
delimited)(.txt).']
echo ![b+' Transfer the file to =
the HP3000 as ASCII. Set host record']
echo ![b+' size to 1000 (so the =
file won't wrap). Make sure to NOT']
echo ![b+' convert TABs to =
SPACEs.']
echo ![b+'']
echo
![s+'F;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;=
;;;;;;;;']
#
# Author: Robert W.Mills
#
<very large snip to hide very untidy alpha =
code>
Modification History:
Versn | Date | =
Who | Reason for Change
------+------------+-----+-------------------------------------=
-----
01.00 | dd/mm/2001 | RWM | Initial version. Based on =
DELIM.QZPRGMS
=
| =
| | written by Kim A.Williams =
(11/08/98).
=
| =
| | Now handles any size file but is =
slower
=
| =
| | than original (reads input file =
twice).
#=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# End of command file.
#=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
*****************************
Robert W.Mills, Systems Development Manager, =
Windsong Services
Electron House, Cray Avenue, St. Mary Cray, =
Kent BR5 3PN, ENGLAND
Tel: +44 (0)1689.870622 x 3005 Fax: +44 =
(0)1689 899026
robert.mills@windsong-services.co.uk
********************************
The thoughts, comments, and opinions expressed =
herein are mine.
They do not reflect those of my employer, nor anyone =
else.
********************************
***Confidentiality Notice: This e-mail message, =
including any attachments,
is for the sole use of the intended recipient(s) and =
may contain
confidential and privileged information. Any =
unauthorized review, use,
disclosure or distribution is prohibited. If you are =
not the intended
recipient, please contact the sender by reply e-mail =
and destroy all copies
of the original message.
-----Original Message-----
From: Seamus BROWNE [mailto:Seamus.Browne@partage.o=
rg]
Sent: 17 October 2001 14:50
To: powerh-l@lists.swau.edu
Subject: QTP, QUIZ Files with commas.
Hi,
I found your posting on the PH list, concerning the =
commas within records.
On a HP3000, the awk utility
Someone already suggested in reply to your posting =
that it would be easier
to do the REPLACE op outside of PH, from =
within a job.
HP3000 users have access to the Unix ( PosiX ) =
utility "awk". AWK.HPBIN.SYS.
Awk seems to be the standard for parsing, replacing =
data in files or
building new files
with reformatted data (using the printf function) =
.
I have not used it, yet.
The syntax is here <http://vectorsite.tripod.com/tsawk2.html#m2>
http://vectorsite.tripod.com/tsawk2.html#m2=
Now if I may widen the debate.
We are having the same kind of comma problem =
here. Or soon will be, when
we start receiving big files from Internet cgis. =
(Common gateway interfaces)
Fields in these files are separated by "|" =
or commas or semi-colons and the
object of the game is to get them into the (Image) =
database.
Now I think that that is problem that will be facing =
hundreds of PH users
the
world over.
Introducing a REPLACE function in QTP and QUIZ would =
certainly increase
efficiency, but in world where file portability is =
an absolute necessity, it
would
only be a very small step.
What I am looking for is a file conversion utility =
that would take a file
from the Net,
full of data with separators and transform it into a =
standard PH subfile.
Or even a PH "portable subfile" (i.e. a =
data file and a mini-dictionary
file). When
I say a file conversion utility, this could be a job =
or command file that
calls awk
and/or other stuff but eventually produces a file =
directly recognisable by
PH
and without the hassle of declaring a file in the =
dictionary.
Anyone interested in putting this together ?
Seamus.Browne@partage.org
------_=_NextPart_001_01C157B6.52CDADC0--