QUIZ and subfiles
dbrzak
dbrzak at shaw.ca
Thu Mar 30 16:57:28 CDT 2023
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.It's been a while since I did this but that's what I seeSent from my Galaxy
-------- Original message --------From: "James B. Byrne" <byrnejb at harte-lyne.ca> Date: 2023-03-30 3:40 p.m. (GMT-07:00) To: powerh-l at lists.sowder.com Subject: QUIZ and subfiles I am trying to produce a CSV file from a type 642 QUIZ SUBFILE. The QUIZscript compiles ok but when it is run it does not create the expected outputfile. If I run the script without the SET SUBFILE statement in it then theoutput that appears on the terminal is what I am trying to save to a file.If I run the compiled script then all that appears to happen is that the QUIZ >prompt appears.Has anyone any idea what I have tripped over? The problem script is:SET NOSUBFILEACCESS *QZART5A1DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'DEFINE QZD-DELIM CHARACTER SIZE 1 = ','DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'SORT ON QZD-NET D & ON ACCOUNT-NUMBERREPORT SUMMARY & QZD-QUOTE & ACCOUNT-NUMBER & QZD-QDELIMQ & DESCRIPTION & QZD-QDELIMQ & QZD-GROSS & QZD-QDELIMQ & QZD-NET & QZD-QDELIMQ & QZD-NET-R & QZD-QDELIMQ & QZD-COUNT & QZD-QUOTESET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2 KEEP & NODICTIONARY PORTABLE SIZE 9600SET REPORT LIMIT 500000BUILD QZART5AB-- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-MailJames B. Byrne mailto:ByrneJB at Harte-Lyne.caHarte & Lyne Limited http://www.harte-lyne.ca9 Brockley Drive vox: +1 905 561 1241Hamilton, Ontario fax: +1 905 561 0757Canada L8E 3C3-- = = = = = = = = = = = = = = = = = = = = = = = = = = = =Mailing list: powerh-l at lists.sowder.comSubscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.comUnsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.comhttps://lists.sowder.com/mailman/listinfo/powerh-lThis list is closed, thus to post to the list you must be a subscriber.Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230330/d3355800/attachment.html>
More information about the powerh-l
mailing list