5 Replies Latest reply: May 15, 2014 9:56 AM by Grant Perkins RSS

    Record with multiple lines

    River _

      Having problems trapping data from a record where the description is on line 1 and the amount is on the 2nd line.(This is true in most case and less the  description line is followed by the report header making the amount line appear on the next page after the report header. 

        • Record with multiple lines
          Grant Perkins

          Hi River and welcome to the forum.

           

          For the Page Break - you should be able to work with this if you define Page Header template for the lines of the page header that you want to mask from the main process. (You can still extract information from the Page Header template if you need to just like any other template.)

           

          For the multiple lines - if we assume the page break problem is fixed from the above, do you always have 2 lines in the record? Or do you sometomes have only one?

           

          If always two lines a 2 line Detail template should be all you need.

           

          If sometimes you have one line records you may need to consider using a single line sample for the template and setting a multiline field to grab the second line when there is one. To do this paint the field where you need it and right click on the highlight area to access the advanced field properties to set how best to define the multi-line trap you need.

           

          The Learning Guide is useful if you have access to one. Also the Help included from the Monarch menu bar.

           

          There are plenty of people on here who will help more if you need it but it would be best to paste a sample (real or made up) of the format of the report you are dealing with in order to get the most beneficial input. We understand that may not always be possible but it is a great help. (I am assuming that the report is a 'standard' format and not some form of Excel database, html or other non-simple type.)

           

          I hope that takes you forward at least a little way!

           

          Grant

          • Record with multiple lines
            River _

            Grant, thanks for quick reply. I will try the steps. Below is a sample of the data

             

            Thanks

             

              CHARGES FOR PERIOD ENDING           31-MAY-2007                                                                               

            AT&T Business Services                                                                               

            AT&T VPN                                                                               

            MPLS PORT-1.544 MBPS                                                                               

            1 Months                        $493.48 

                        COS PACKAGE MULTIMEDIA HIGH SVC-1.544 MBPS                                                                               

            1 Months                        $197.34 

                        LOCAL ACCESS-1536 KBPS (T1)                                                                               

            1 Months                        $102.50 

                Total AT&T VPN                                                                               

            Total AT&T Business Services                                                                               

            CHARGES FOR PERIOD ENDING           30-JUN-2007                                                                               

            AT&T Business Services                                                                               

            AT&T VPN                                                                               

            MPLS PORT-1.544 MBPS                                                                               

            All charges are in Canadian dollars                                                                               

            Site: SCHLCALAB04                                                                               

            Attention:                                                              (CONTINUED)                                              

              600-322 11 AV SW                                                                               

            CALGARY, AB       T2R0C5            CALGAR AB T2R0C5                                                                               

            CANADA                                                                               

            Site Alias:    Calgary CTC CA0040                                                                               

            Service Category                                                                               

            Service Type                                                                         Quantity                           Rate                                                                               

            1 Months                        $493.48 

                        COS PACKAGE MULTIMEDIA HIGH SVC-1.544 MBPS                                                                               

            1 Months                        $197.34 

                        LOCAL ACCESS-1536 KBPS (T1)                                                                               

            1 Months                        $102.50 

                Total AT&T VPN                                                                               

            Total AT&T Business Services

            • Record with multiple lines
              Grant Perkins

              River,

               

              Just in case you have further queries I will post the report as 'code'. Does this represent the format reasonably accurately?

               

              Originally posted by River:

              [font="courier"]  CHARGES FOR PERIOD ENDING           31-MAY-2007                                                                               

              AT&T Business Services                                                                               

              AT&T VPN                                                                               

              MPLS PORT-1.544 MBPS                                                                               

              1 Months                        $493.48 

                          COS PACKAGE MULTIMEDIA HIGH SVC-1.544 MBPS                                                                               

              1 Months                        $197.34 

                          LOCAL ACCESS-1536 KBPS (T1)                                                                               

              1 Months                        $102.50 

                  Total AT&T VPN                                                                               

              Total AT&T Business Services                                                                               

              CHARGES FOR PERIOD ENDING           30-JUN-2007                                                                               

              AT&T Business Services                                                                               

              AT&T VPN                                                                               

              MPLS PORT-1.544 MBPS                                                                               

              All charges are in Canadian dollars                                                                               

              Site: SCHLCALAB04                                                                               

              Attention:                                                              (CONTINUED)                                              

                600-322 11 AV SW                                                                               

              CALGARY, AB       T2R0C5            CALGAR AB T2R0C5                                                                               

              CANADA                                                                               

              Site Alias:    Calgary CTC CA0040                                                                               

              Service Category                                                                               

              Service Type                                                                         Quantity                           Rate                                                                               

              1 Months                        $493.48 

                          COS PACKAGE MULTIMEDIA HIGH SVC-1.544 MBPS                                                                               

              1 Months                        $197.34 

                          LOCAL ACCESS-1536 KBPS (T1)                                                                               

              1 Months                        $102.50 

                  Total AT&T VPN                                                                               

              Total AT&T Business Services[/font][/quote][/b][/quote]

              • Record with multiple lines
                River _

                Grant,

                Yes, the page ends after "All Charges are in Canadian dollars" and begins with "Site: "

                 

                Thanks again

                • Record with multiple lines
                  Grant Perkins

                  Originally posted by River:

                  Grant,

                  Yes, the page ends after "All Charges are in Canadian dollars" and begins with "Site: "

                   

                  Thanks again /b[/quote]Hmm,

                   

                  That could be 'interesting'.

                   

                  It may be worth redefining the layout (if it does not mess up the first page ...) so that the virtual Page Header starts before "All charges ..." and then ends after all the regular page header headers. It may even be worth starting a line or two above "All charges ...." if there are consistently 2 space lines included.

                   

                  Just a couple of thoughts in case things don't quite seem to work out as expected!

                   

                   

                  Grant