1 Reply Latest reply: May 15, 2014 9:55 AM by Grant Perkins RSS

    Variable Line Trap Problem - Lurker comes out

    Pat Donnelly

      Hey Guys,

       

      My problem involves the "Instruction X:" lines in the sample below.

       

      All Permutations or Combinations exist. Including no Instruction line at all. 

       

      I am happy treating the fields as fixed to the same length as the longest one.  No need to make it harder that it has to be.

       

      I do need all the lines to be on the same row in the (Table View) output.  I don't care if I get 1,2 or 3 fields.

       

      I have tried to do this a number of was by the results are always as unpredictable as the input.

       

       

      Thanks for your help.

       

      Pat Donnelly

      Ready Mixed Concrete, Co

      Raleigh, NC

      [font="courier"] 

      -


                                                                                       

      18745502     87455  WALLACE BUILDERS INC/RICHARD                             01-Apr-99      CD       1           C    A       1     

                      87455  ALL JOBS                                                 31-Mar-04      CG                                      

                             ALL JOBS                                                                BL                                                                               

      Tax  ----Tax Code----     Term Price  Disc                   Pr Esc 1      Pr Esc 2      Pr Esc 3      Pr Esc 4     Hl Esc 1    

      Date: 02-Dec-03                                   RMC - RALEIGH/DURHAM DIVISION                                             Page 518   

      Time: 16:06                                             Long Project List                                                      CD/32                                                                               

      Sequence : Sorted by project number                                                                               

      Project      Customer/ Customer name/                P/O number/      Est Qty/   Start/    Est    Sch Bill  Zone   Sale Stat/ Cr Cd/   

      Number       Bill to   Project name  /Project addr   Cust. job        Unpr Date Exp Date  Trvl    Plt Plt           Man Map page       

      ====================================================================================================================================   

      Typ  ST    CNTY                 Code Type   Amount  H M U P S L G  Date/Amt      Date/Amt      Date/Amt      Date/Amt     Date/Amt    

          1    6   WK                CD   2   1            N 0 N N 0 T N                                                                     

        Lost to code                 CG       0                                                                                0.00      

         Lost Reason                 BL       0           Minimum lien amount                                                                               

      Code/              Code/              Code/              Code/              Code/             Start                

        Stratified         Amt     Up to      Amt     Up to      Amt      Up to     Amt    Up to       Amt       Up to  Date                 

        CD  Terms                                                                               

      Disc/unit                                                                               

      Contact                       Job phone (   )-000-0000                                                                               

      Instruction line 1: GO THRU GUARD SHACK/RT SHAWNEE/L-F CHOCHESE/LF SAGAMORE/JOB ON RT   5 sack up  : 0.00        Min Lds    0         

      Instruction line 3: ON RT                           -                                   5 sack down: 0.00        Pre Note                                                                               

      -


                                                                                       

      12980301     29803  EVANS LANDSCAPE CO/JAY W                                 07-Jun-00      CD       1           K    A       1     

                      29803  ALL JOBS                                                 31-Mar-04      CG                                      

                             ALL JOBS                                                                BL                                                                               

      Tax  ----Tax Code----     Term Price  Disc                   Pr Esc 1      Pr Esc 2      Pr Esc 3      Pr Esc 4     Hl Esc 1    

      Typ  ST    CNTY                 Code Type   Amount  H M U P S L G  Date/Amt      Date/Amt      Date/Amt      Date/Amt     Date/Amt    

          1    6   WK                CD   2   1            N 0 N N 0 T N                                                                     

        Lost to code                 CG       1                                                                                0.00      

         Lost Reason                 BL       1           Minimum lien amount                                                                               

      Code/              Code/              Code/              Code/              Code/             Start                

        Stratified         Amt     Up to      Amt     Up to      Amt      Up to     Amt    Up to       Amt       Up to  Date                 

        CD  Terms                                                                               

      Disc/unit                                                                               

      Contact JAY W EVANS           Job phone (919)-217-9583                                                                               

      Instruction line 1: TRYON RD/YATES MILL POND RD/RT  -THEYS/RT SUB/1ST RT/RT THISTLETO   5 sack up  : 0.00        Min Lds    0         

      Instruction line 2: N                               -                                   5 sack down: 0.00        Pre Note             

      Instruction line 3: LOT ON RT                       -                                                                               

      Plt  Product     Long/Short              Slm                                                                               

      1.     Number    Description         Pkg Inc Min Typ UOM Price 1 Price 2 Price 3 Price 4 Price 5 HlChg 1 HlChg 2 Est Qty  Usage        

                14   1-2 TOPPING                    Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                19   3000 PSI BM                    Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                25   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               101   3000 PSI CHT PMP               Y   1  YARD  xx.30    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               133   3500 PSI RESIDEN               Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               183   2500 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               184   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               186   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               188   4000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               190   3000 PSI CURB                  Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               195   3000 PUMP CHATS                Y   1  YARD  xx.30    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

               567   ENVIRONMNTAL FEE               Y   7  EA     x.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN                                                                               

      -


          /font[/quote]

        • Variable Line Trap Problem - Lurker comes out
          Grant Perkins

          Hi Pat,

           

          I'm not sure what you are using as your detail data - the first 'record' in you sample does not seem to have anything obvious!

           

          That is not a problem but it means I am not sure if the "Instructions" text should be part of the detail or perhaps an Append template or even a footer. However assuming you can work out where to best include the field I would suggest that you use the multi-line field capability and take the entire block of text if it exists.

           

          You can do this by including the section of the report in a template somewhere (only the first line is important to us for this proposal) then highlight the maximum possible field width by 'painting' the field on screen. Right click on the field to get to the field properties. (Or whatever method you prefer to do that).

           

          Use the PRECEEDING STRING option to set where the 'field start' is to be identified. "Instructions line 1:" would do it but "line 1:" looks like it might be enough.

           

          Set the "End Field On" option to "Blank Field Values" with a value of 1.

           

          That should then give a single field which includes 0 to n lines from the report. I assume n is not an infinite number so leaving it as a character field should be OK. If not consider making it a memo field type.

           

          You are likely to end up with some odd formatting in the field - blank sections and so on. The field could be tidied up, split out into sections or whatever is required but the best way to do that depends to some extent on which version of Monarch you have. I am guessing that you probably already have the requisite knowledge in those areas but if not just let us know the details of challenge!

           

          I hope this helps.

           

          Grant

           

           

          Originally posted by Pat Donnelly:

          Hey Guys,

           

          My problem involves the "Instruction X:" lines in the sample below.

           

          All Permutations or Combinations exist. Including no Instruction line at all. 

           

          I am happy treating the fields as fixed to the same length as the longest one.  No need to make it harder that it has to be.

           

          I do need all the lines to be on the same row in the (Table View) output.  I don't care if I get 1,2 or 3 fields.

           

          I have tried to do this a number of was by the results are always as unpredictable as the input.

           

           

          Thanks for your help.

           

          Pat Donnelly

          Ready Mixed Concrete, Co

          Raleigh, NC

          [font="courier"] 

          -


                                                                                           

          18745502     87455  WALLACE BUILDERS INC/RICHARD                             01-Apr-99      CD       1           C    A       1     

                          87455  ALL JOBS                                                 31-Mar-04      CG                                      

                                 ALL JOBS                                                                BL                                                                               

          Tax  ----Tax Code----     Term Price  Disc                   Pr Esc 1      Pr Esc 2      Pr Esc 3      Pr Esc 4     Hl Esc 1    

          Date: 02-Dec-03                                   RMC - RALEIGH/DURHAM DIVISION                                             Page 518   

          Time: 16:06                                             Long Project List                                                      CD/32                                                                               

          Sequence : Sorted by project number                                                                               

          Project      Customer/ Customer name/                P/O number/      Est Qty/   Start/    Est    Sch Bill  Zone   Sale Stat/ Cr Cd/   

          Number       Bill to   Project name  /Project addr   Cust. job        Unpr Date Exp Date  Trvl    Plt Plt           Man Map page       

          ====================================================================================================================================   

          Typ  ST    CNTY                 Code Type   Amount  H M U P S L G  Date/Amt      Date/Amt      Date/Amt      Date/Amt     Date/Amt    

              1    6   WK                CD   2   1            N 0 N N 0 T N                                                                     

            Lost to code                 CG       0                                                                                0.00      

             Lost Reason                 BL       0           Minimum lien amount                                                                               

          Code/              Code/              Code/              Code/              Code/             Start                

            Stratified         Amt     Up to      Amt     Up to      Amt      Up to     Amt    Up to       Amt       Up to  Date                 

            CD  Terms                                                                               

          Disc/unit                                                                               

          Contact                       Job phone (   )-000-0000                                                                               

          Instruction line 1: GO THRU GUARD SHACK/RT SHAWNEE/L-F CHOCHESE/LF SAGAMORE/JOB ON RT   5 sack up  : 0.00        Min Lds    0         

          Instruction line 3: ON RT                           -                                   5 sack down: 0.00        Pre Note                                                                               

          -


                                                                                           

          12980301     29803  EVANS LANDSCAPE CO/JAY W                                 07-Jun-00      CD       1           K    A       1     

                          29803  ALL JOBS                                                 31-Mar-04      CG                                      

                                 ALL JOBS                                                                BL                                                                               

          Tax  ----Tax Code----     Term Price  Disc                   Pr Esc 1      Pr Esc 2      Pr Esc 3      Pr Esc 4     Hl Esc 1    

          Typ  ST    CNTY                 Code Type   Amount  H M U P S L G  Date/Amt      Date/Amt      Date/Amt      Date/Amt     Date/Amt    

              1    6   WK                CD   2   1            N 0 N N 0 T N                                                                     

            Lost to code                 CG       1                                                                                0.00      

             Lost Reason                 BL       1           Minimum lien amount                                                                               

          Code/              Code/              Code/              Code/              Code/             Start                

            Stratified         Amt     Up to      Amt     Up to      Amt      Up to     Amt    Up to       Amt       Up to  Date                 

            CD  Terms                                                                               

          Disc/unit                                                                               

          Contact JAY W EVANS           Job phone (919)-217-9583                                                                               

          Instruction line 1: TRYON RD/YATES MILL POND RD/RT  -THEYS/RT SUB/1ST RT/RT THISTLETO   5 sack up  : 0.00        Min Lds    0         

          Instruction line 2: N                               -                                   5 sack down: 0.00        Pre Note             

          Instruction line 3: LOT ON RT                       -                                                                               

          Plt  Product     Long/Short              Slm                                                                               

          1.     Number    Description         Pkg Inc Min Typ UOM Price 1 Price 2 Price 3 Price 4 Price 5 HlChg 1 HlChg 2 Est Qty  Usage        

                    14   1-2 TOPPING                    Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                    19   3000 PSI BM                    Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                    25   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   101   3000 PSI CHT PMP               Y   1  YARD  xx.30    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   133   3500 PSI RESIDEN               Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   183   2500 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   184   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   186   3000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   188   4000 PSI                       Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   190   3000 PSI CURB                  Y   1  YARD  xx.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   195   3000 PUMP CHATS                Y   1  YARD  xx.30    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN       

                   567   ENVIRONMNTAL FEE               Y   7  EA     x.00    0.00    0.00    0.00    0.00    0.00    0.00     0.00 UKNOWN                                                                               

          -


              /font[/quote][/b][/quote]