<br>as a field delimiter, I generally use the vertical bar "|".<div style="font-size: 12pt; font-family: Arial;"><p style="font-size: 12pt; font-family: Arial;">Olav.</p><br>        <br>        <blockquote><br>        <br>   ------ Original Message ------<br>   From: tmjva23664@gmail.com<br>   To: powerh-l@lists.sowder.com<br>   Sent: Thursday, March 30, 2023 5:51 PM<br>   Subject: Re: QUIZ and subfiles<br>  <br>             <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>              <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: 12.0px;color: rgb(87,87,87);" dir="auto">Sent from           my Galaxy</div>       </div>       <div dir="auto"><br>       </div>       <div><br>       </div>       <div dir="auto" style="font-size: 100.0%;color: rgb(0,0,0);" align="left">         <div>-------- Original message --------</div>         <div>From: "James B. Byrne" <a class="moz-txt-link-rfc2396E" href="mailto:byrnejb@harte-lyne.ca"><<span class="wt_Email">byrnejb@harte-lyne.ca</span><span></span>></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"><span class="wt_Email">powerh-l@lists.sowder.com</span><span></span></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" target="_blank">http://www.harte-lyne.ca</a><br>       9 Brockley Drive              vox: <span class="wt_Phone">+1 905 561 1241</span><span></span><br>       Hamilton, Ontario             fax: <span class="wt_Phone">+1 905 561 0757</span><span></span><br>       Canada  L8E 3C3<br>       <br>       -- <br>       = = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>       Mailing list: <a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com"><span class="wt_Email">powerh-l@lists.sowder.com</span><span></span></a><br>       Subscribe: 'subscribe' in message body to       <a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com"><span class="wt_Email">powerh-l-request@lists.sowder.com</span><span></span></a><br>       Unsubscribe: 'unsubscribe &lt;password&gt;' in message       body to <a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com"><span class="wt_Email">powerh-l-request@lists.sowder.com</span><span></span></a><br>       <a class="moz-txt-link-freetext" href="https://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">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">-- <br>Tracy Johnson<br>BT<br><br><br><br><br><br><br><br>NNNN</pre>     <hr>-- <br><br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br><br>Mailing list: <span class="wt_Email">powerh-l@lists.sowder.com</span><span></span><br><br>Subscribe: 'subscribe' in message body to <span class="wt_Email">powerh-l-request@lists.sowder.com</span><span></span><br><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <span class="wt_Email">powerh-l-request@lists.sowder.com</span><span></span><br><br><a target="_blank" href="https://lists.sowder.com/mailman/listinfo/powerh-l">https://lists.sowder.com/mailman/listinfo/powerh-l</a><br><br>This list is closed, thus to post to the list you must be a subscriber.<br><br>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<br><br><br>        </blockquote><br>        <br>        </div>