QUIZ and subfiles

[RUTMJVA]

And SET NOHEADING

I think the only other limitation is that the report width may be 
limited.  Can save width space with

SET REPORT SPACING 0

Otherwise it defaults to 2 spaces.

If there are commas in the data there could be other issues. Usually 
solved with space or tab delimiters and import it column aligned.


On 3/30/23 17:57, dbrzak wrote:
> 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 see
>
>
>
> Sent 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 QUIZ
> script compiles ok but when it is run it does not create the expected 
> output
> file.  If I run the script without the SET SUBFILE statement in it 
> then the
> output 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 NOSUBFILE
>
> ACCESS *QZART5A1
>
> DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'
> DEFINE QZD-DELIM CHARACTER SIZE 1 = ','
> DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'
>
> SORT ON QZD-NET D &
>      ON ACCOUNT-NUMBER
>
> REPORT 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-QUOTE
>
> SET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2 KEEP &
>     NODICTIONARY PORTABLE SIZE 9600
>
> SET REPORT LIMIT 500000
>
> BUILD 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-Mail
>
> James B. Byrne mailto:ByrneJB at Harte-Lyne.ca
> Harte & Lyne Limited http://www.harte-lyne.ca
> 9 Brockley Drive              vox: +1 905 561 1241
> Hamilton, Ontario             fax: +1 905 561 0757
> Canada  L8E 3C3
>
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to 
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to 
> powerh-l-request at lists.sowder.com
> https://lists.sowder.com/mailman/listinfo/powerh-l
> This 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.
>

-- 
Tracy Johnson
BT







NNNN

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230330/cb006c9d/attachment.html>