<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body dir="auto"><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 align="left" dir="auto" style="font-size:100%;color:#000000"><div>-------- Original message --------</div><div>From: "James B. Byrne" <byrnejb@harte-lyne.ca> </div><div>Date: 2023-03-30 3:40 p.m. (GMT-07:00) </div><div>To: powerh-l@lists.sowder.com </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 mailto:ByrneJB@Harte-Lyne.ca<br>Harte & Lyne Limited http://www.harte-lyne.ca<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: powerh-l@lists.sowder.com<br>Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request@lists.sowder.com<br>https://lists.sowder.com/mailman/listinfo/powerh-l<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.</body></html>