3 Replies Latest reply: May 15, 2014 9:54 AM by Grant Perkins RSS

    HELP

    ERock _

      Can V8 deal with lines of data that are not consistent.  In the example, sometimes an entire section of data may have 4 lines, but then it will have 3 lines.  I can't seem to get V8 to capture all the data consistently, especially since some of the data on the first line continues into the second line. 

       

      0001    15,000-TESTER TEST HEALTHTEST & HSG R 10 37 67

      0002           Continued from top after R                                     

      0003               DATE ACCOUNT OPENED    03/06/26

      0004           07/01/2033   5.500

      0005  2500,000-TESTER IS ST ECONOMIC DEV TEST  13 37 67

      0006           TESTA ATTTT-R I DEPT TRANS-T                         

      0007               DATE ACCOUNT OPENED    06/09/26

      0008           06/15/2016   5.000

      0009 16120,000-TESTER ST GO REF BDS 2005A     13 37 67  

      0010           GO                                                  

      0011               DATE ACCOUNT OPENED    06/09/26

      0012           02/01/2014   5.000

      0013  3000,000-TESTRR TTT TT TT                13 37 67

      0014               DATE ACCOUNT OPENED    06/09/26                

      0015           11/01/2016   5.000

        • HELP
          Grant Perkins

          Hi and welcome to the forum.

           

          Is this how the report actually looks?

           

          Originally posted by ERock:

            

          [font="courier"]0001    15,000-TESTER TEST HEALTHTEST & HSG R 10 37 67

          0002           Continued from top after R                                     

          0003               DATE ACCOUNT OPENED    03/06/26

          0004           07/01/2033   5.500

          0005  2500,000-TESTER IS ST ECONOMIC DEV TEST  13 37 67

          0006           TESTA ATTTT-R I DEPT TRANS-T                         

          0007               DATE ACCOUNT OPENED    06/09/26

          0008           06/15/2016   5.000

          0009 16120,000-TESTER ST GO REF BDS 2005A     13 37 67  

          0010           GO                                                  

          0011               DATE ACCOUNT OPENED    06/09/26

          0012           02/01/2014   5.000

          0013  3000,000-TESTRR TTT TT TT                13 37 67

          0014               DATE ACCOUNT OPENED    06/09/26                

          0015           11/01/2016   5.000 /font[/quote][/b][/quote]Grant

          • HELP
            ERock _

            Yes, that is how it looks. 

             

            Thanks!

            • HELP
              Grant Perkins

              OK, you have a couple of challenges. Depending on what you want to extract and how it needs to look there are a few approaches possible. These are based on the sample - if the report has other information that changes the content at other places they may not work at all or may not work without further adaptation.

               

              Firstly - your data sample seems to be limited to 3 lines as per lines 13 through 15 in your sample - the record without the extended description line.

               

              You can look for a way of extracting all the data as a DETAIL record using a 3 line sample or you could think of it as a 2 line DETAIL (the last two lines trapped using "DATE ACCOUNT OPENED" as the first line, and then an append, probably trapped on the hyphen in the line with a numeric character in front of it, the grab the rest of the record.

               

              If we cionsider the DETAIL and APPEND option first the two traps seem to be quite straightforward. The problem with the description that often creates a second line can be solved using a MULTI ROW  field.

               

              Define the field as a single field for the maximum width (up to the "R" in the example you specifically mentioned. Right click on the field to access the Advanced Properties. In the "End field on" section choose a suitable option. Do not use the specified number of lines option but do use one of the others. "End of left justification" may work for example. Or if all else fails - "none of the above" usually gives results. It would be worth taking the opportunity just to play with the options to see what they do, it only takes a couple of minutes.

               

              That should deal with your wrapped description when it appears.

               

               

              If you want to try the extraction as a single DETAIL template, select the 3 row sample and trap on the first line as for the append option above. Treat the wrapped description field in the same way as above.

               

              On the second line of the field definition area paint a field where the DATE for the 'Date Account Opened' field will be. Go into the field Advanced Properties and set the 'Start Field on:' to be 'preceding string' of "date account opened" on the current line. Monarch will then find that date whether it appears in the second or third line of the record. (Or even further down than that ...)

               

              For the fields on the last line of the record you can probably paint the fields where they should be on the third line of the sample and use the 'preceding sting on the previous line' option to select the data. The preceding string would again be "date account opened". Or you may be able to use the 'After the last field in the template' option. (You could certainly use that to extract that line as a single field and then split it into two field using calculated fields and the LSPLIT() and/or RSPLIT() function(s)).

               

              These are not the only options available to you so if you are still stuck for a complete solution because there are other problems elsewhere in the report we still have some other lines of investigation open to us.

               

              HTH.

               

              Grant