<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="4"><font face="monospace">And SET NOHEADING<br>
<br>
I think the only other limitation is that the report width may
be limited. Can save width space with <br>
<br>
SET REPORT SPACING 0 <br>
<br>
Otherwise it defaults to 2 spaces.<br>
<br>
If there are commas in the data there could be other issues.
Usually solved with space or tab delimiters and import it column
aligned.<br>
<br>
</font></font><br>
<div class="moz-cite-prefix">On 3/30/23 17:57, dbrzak wrote:<br>
</div>
<blockquote type="cite"
cite="mid:202303302157.32ULvZ3m001547@dal2.xzwq.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div dir="auto">The comma variable should be one character not
three and this should be saved as a report not a subfile and the
output should be imported into excel as a comma delimited text
file.</div>
<div dir="auto"><br>
</div>
<div dir="auto">It's been a while since I did this but that's what
I see</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div id="composer_signature" dir="auto">
<div style="font-size:12px;color:#575757" dir="auto">Sent from
my Galaxy</div>
</div>
<div dir="auto"><br>
</div>
<div><br>
</div>
<div dir="auto" style="font-size:100%;color:#000000" align="left">
<div>-------- Original message --------</div>
<div>From: "James B. Byrne" <a class="moz-txt-link-rfc2396E" href="mailto:byrnejb@harte-lyne.ca"><byrnejb@harte-lyne.ca></a> </div>
<div>Date: 2023-03-30 3:40 p.m. (GMT-07:00) </div>
<div>To: <a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a> </div>
<div>Subject: QUIZ and subfiles </div>
<div><br>
</div>
</div>
I am trying to produce a CSV file from a type 642 QUIZ SUBFILE.
The QUIZ<br>
script compiles ok but when it is run it does not create the
expected output<br>
file. If I run the script without the SET SUBFILE statement in it
then the<br>
output that appears on the terminal is what I am trying to save to
a file.<br>
<br>
If I run the compiled script then all that appears to happen is
that the QUIZ ><br>
prompt appears.<br>
<br>
Has anyone any idea what I have tripped over? The problem script
is:<br>
<br>
SET NOSUBFILE<br>
<br>
ACCESS *QZART5A1<br>
<br>
DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'<br>
DEFINE QZD-DELIM CHARACTER SIZE 1 = ','<br>
DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'<br>
<br>
SORT ON QZD-NET D
&<br>
ON ACCOUNT-NUMBER<br>
<br>
REPORT SUMMARY
&<br>
QZD-QUOTE
&<br>
ACCOUNT-NUMBER
&<br>
QZD-QDELIMQ
&<br>
DESCRIPTION
&<br>
QZD-QDELIMQ
&<br>
QZD-GROSS
&<br>
QZD-QDELIMQ
&<br>
QZD-NET
&<br>
QZD-QDELIMQ
&<br>
QZD-NET-R
&<br>
QZD-QDELIMQ
&<br>
QZD-COUNT
&<br>
QZD-QUOTE<br>
<br>
SET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2 KEEP
&<br>
NODICTIONARY PORTABLE SIZE 9600<br>
<br>
SET REPORT LIMIT 500000<br>
<br>
BUILD QZART5AB<br>
<br>
<br>
-- <br>
*** e-Mail is NOT a SECURE channel ***<br>
Do NOT transmit sensitive data via e-Mail<br>
Unencrypted messages have no legal claim to privacy<br>
Do NOT open attachments nor follow links sent by e-Mail<br>
<br>
James B. Byrne <a class="moz-txt-link-freetext" href="mailto:ByrneJB@Harte-Lyne.ca">mailto:ByrneJB@Harte-Lyne.ca</a><br>
Harte & Lyne Limited <a class="moz-txt-link-freetext" href="http://www.harte-lyne.ca">http://www.harte-lyne.ca</a><br>
9 Brockley Drive vox: +1 905 561 1241<br>
Hamilton, Ontario fax: +1 905 561 0757<br>
Canada L8E 3C3<br>
<br>
-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: 'unsubscribe <password>' in message
body to <a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
<a class="moz-txt-link-freetext" href="https://lists.sowder.com/mailman/listinfo/powerh-l">https://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a
subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to
search the list archive at Google.<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Tracy Johnson
BT
NNNN</pre>
</body>
</html>