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

    Covert to single line

    Searching _

      Hello everyone

       

      Any idea how I can get Monarch to put all data on on line for each id instead of how it looks now?

       

      ID  PRC                    Start  Stop

       

      115 -Coaching Manager      13:00  13:30     

          -Close Outbound        13:30  15:00     

          -Break                 15:00  15:15     

          -Close Outbound        15:15  16:30     

          -Lunch                 16:30  17:00     

          -Close Outbound        17:00  19:00     

          -Break                 19:00  19:15     

          -Close Outbound        19:15  21:00

             

      1743 -Pre Shift            13:30  14:00         

           -Coaching Manager     14:00  14:15   

           -Close Outbound       14:15  14:45     

           -Break                14:45  15:00     

           -Close Outbound       15:00  16:30     

           -Lunch                16:30  17:00   

           -Close Outbound       17:00  19:00    

       

      Thanks

        • Covert to single line
          Steve Caiels

          Hi,

           

          The advanced field option to get all the data into one field, followed by a series of calculated fields should do this.

           

          1.     Trap using Numeric on the first column of the first line (assuming this is constant and OK for the rest of the report)

           

          2.     Highlight the entire width of the line, then use the blank field options in the advance tab of the field properties to extract all the data into one field.

          Maybe that’s it??  If you don’t want it separated out, you will have all the data on one line.  Call the field all

           

          3.     To separate it, create 8 (or more) calculated field using the lsplit function.  The formula will be LSplit(all,8,”-“,1) for the first part, then just change the last parameter for the other 7 parts.  Call the fields part1, part2 etc.

           

          4.     If you need to split it further into description and the two times, you could split further using the RSplit(part1,3,” “,1) etc.

           

           

          Hope that makes sense?

           

          Cheers

          Steve

          • Covert to single line
            Searching _

            Hi Steve

             

            Sorry I don't

            It seems to only put the ID First PRC and Start Stop in the row, not all PRC and Start Stop Data.

             

            I'm probably misunderstanding.

             

            Fred

            • Covert to single line
              Grant Perkins

              Originally posted by Searching:

              Hi Steve

               

              Sorry I don't

              It seems to only put the ID First PRC and Start Stop in the row, not all PRC and Start Stop Data.

               

              I'm probably misunderstanding.

               

              Fred /b[/quote]Steve said

               

              "2. Highlight the entire width of the line, then use the blank field options in the advance tab of the field properties to extract all the data into one field."

               

              This relates to the 'End Field on' properties which will allow you to create a multi-row block as a single text field. There are several options that can be chosen to identify the end of the 'block'. Steve's suggestion is to use the blank line between records. Seems good to me but you might find it worth trying some of the other options to see what happens  - a great way to familiarise with the funstionality.

               

              Hope this helps.

               

               

              Grant

              • Covert to single line
                Searching _

                Hello Grant

                 

                I'm clicking on Blank Field values 1 and the row of data in table is still only showing first row of data?

                 

                I've tried for the last hour and am having no luck.

                 

                Fred

                • Covert to single line
                  Grant Perkins

                  Originally posted by Searching:

                  Hello Grant

                   

                  I'm clicking on Blank Field values 1 and the row of data in table is still only showing first row of data?

                   

                  I've tried for the last hour and am having no luck.

                   

                  Fred /b[/quote]When you look at the definition in the REPORT screen what do you see? Does it appear that all rows will be selected?

                   

                  How wide is the field DISPLAY in your table?

                   

                  Have you looked at the contents using the "Show Field Contents" option (very useful for large text fields). The help section is entitled  "Viewing memo and long character fields"

                   

                  Bear in mind I am trying to cover all the quick to assess angles here to save time and some of these suggestions may be irrelevant!

                   

                  Grant

                  • Covert to single line
                    Searching _

                    Hi

                     

                    Yes all rows are selected ok.

                    Display width I set for max 254

                     

                    Field contents does not show anything that table window does.

                     

                    Fred

                    • Covert to single line
                      Grant Perkins

                      Originally posted by Searching:

                      Hi

                       

                      Yes all rows are selected ok.

                      Display width I set for max 254

                       

                      Field contents does not show anything that table window does.

                       

                      Fred /b[/quote]You have mail.

                       

                       

                      Grant