8 Replies Latest reply: May 15, 2014 10:04 AM by Olly Bond RSS

    trap with moving data

    psrs0810 _

      I am trying to trap some details on a report I receive monthly.  The information I need is at the end of each section.

      I can get a trap to pull the HOSP SERV TOTAL, but from there the data underneath is not always consistant.  the next fields I need are labeled CURREVO and CURREVI. 

       

      Any suggestions?

      Thanks

        • trap with moving data
          elginreigner _

          Sample data please?

            • trap with moving data
              psrs0810 _

              HOSP SERV TOTAL  - AME

              CURREVO A        198,211.42         2,287.58         3,701.93             0.00                                             56,410.05        71,443.31             0.00  A

                           B                                5,053.40        17,793.87         7,024.73                        34,496.55             0.00             0.00  B

              YTDREVO A      1,392,523.31       114,388.88       220,770.84        22,479.92                        278,110.37       365,372.39        68,966.92  A

                            B                              5,053.40       161,332.11        41,512.62                         114,805.86           270.00-            0.00  B

              CURFRQO A             1,203               21               22                0                                365              446                0  A

                            B                                 32              131               32                                154                0                0  B

              YTDFRQO A             7,897              606            1,228              116                            1,666            2,066              367  A

                                              B                                 32              942             

              -


              HOSP SERV TOTAL  - CAR

              CURREVI A      4,976,229.65     2,624,707.75       713,447.73        19,747.70                       246,680.60     1,055,256.16             0.00  A

                          B                               0.00       229,006.70        27,617.70                          58,926.55           838.76             0.00  B

              YTDREVI A     26,816,865.29    13,085,130.20     2,882,359.00                        426,272.01     1,345,143.79     6,751,629.97             0.00             A

                           B                               0.00     1,960,520.03       215,311.19                         136,069.42        14,429.68             0.00  B

              CURFRQI A            34,796           17,821            4,862              253                            2,499            7,496                0  A

                          B                                  0            1,253              384                              230                2-               0  B

              YTDFRQI A           204,099          106,692           19,850            2,151                           10,605           49,778                0  A

                           B                                  0           12,267            2,140                            843              227-               0  B

              CURREVO A          3,448.08             0.00         3,263.58             0.00                           184.50             0.00             0.00  A

              YTDREVO A        329,723.77       164,884.94        71,626.95             0.00                          184.50        35,933.74             0.00  A

                           B                               0.00        37,546.62        16,483.02             0.00         3,064.00             0.00  B

              CURFRQO A                44                0               43                0                1                0                0  A

              YTDFRQO A             3,622            1,498            1,066                0                1              434                0  A

                      B                                  0              449              172    

               

              I think some of the information is a little mixed up, but it gives you the idea

                • trap with moving data
                  elginreigner _

                  Do you just need the value at the end of the line for CURREVO and CURREVI? Or do you also need the value at the end of each line for the additional lines for those values as well, like the 'B' part?

                    • trap with moving data
                      Olly Bond

                      Hello PSRS,

                       

                      If you don't always have CURREVO and CURREVI lines, I'd suggest using the "Preceding String" option instead of the floating trap for your data. It looks as if you could break up the numbers using lsplit(intrim(.

                       

                      Best wishes,

                       

                      Olly

                        • trap with moving data
                          psrs0810 _

                          I need the Hosp Serv total - car becuase the 3 letter character after hosp serv total changes for every total.

                          After that I need to pull CURREVO and CURREVI and its balance after the A

                           

                          So my final table I want to see the List of Hosp Serv Total, CURREVI and its total and CURREVO and its total.

                           

                          Olly - I will try the preceding string, but I have not had any luck with that in the past.

                           

                          thanks

                            • trap with moving data
                              psrs0810 _

                              How would I do a preceding string or string to look at Hosp serv total and pull in CURREVO?

                                • trap with moving data
                                  Grant Perkins

                                  Is this the same requirement that we were discussing at the beginning of May? Or is it a variation on that theme?

                                   

                                  I got your PM and replied giving an email address to which you could provide a part of the original file but have not seen anything since then. Do we have an email attachment issue here?

                                   

                                   

                                  Grant

                                    • trap with moving data
                                      Olly Bond

                                      Hello PSRS,

                                       

                                      Grant and I are more than happy to build you a quick model showing the preceding string, but I would recommend getting yourself on to the next Advanced Monarch training course near you, as this would teach you not just one technique but a dozen others as well.

                                       

                                      If you want to try it yourself, select a three line template with the HOSP on line one, as your detail. Trap on HOSP, highlight that field. Then in line 2, highlight the field as if CURREVO was there, double click on the field, select the Advanced tab, click on the Preceding String option, specify CURREVO must appear in that line. Repeat on line 3 for CURREVI. The template will create one row of data in the table for each HOSP, and where CURREVI and CURREVO appear, it will attach these.

                                       

                                      You'll have problems, possibly, with page breaks, and with entries where there's more than one CURREVO or CURREVI for the single HOSP. But from the sample you posted, it shouldn't be too tricky.

                                       

                                      Best wishes,

                                       

                                      Olly