9 Replies Latest reply: May 15, 2014 10:05 AM by mdyoung _ RSS

    Ver 9.01 can I get the second and third lines of the description?

    kbeaton _

      Not sure if you can tell from this sample of data, but what I have are some records that are just one line, others where the second field is a description and was to long to fit on one line, they trunkated the description field, entered the part number again and continued the description followed by the date again and if the description didn't fit in two lines they did it a third time.

       

      I only need the part number (the first field) and the date once, so the repeated entried can be discarded.

       

      Can someone tell me if this is possible and point me in the right direction if it is?

       

      I'm using Monarch Pro version 9.01

       

      Any help would be appreciated!

       

      Thanks

       

      Kelvin

       

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      A02T6   0000010000TIME AND EXPENSE                                                                    1991-02-01

      A02T7   0000010000TIME AND EXPENSE                                                                    1991-02-01

      A02T8   0000010000TIME AND EXPENSE                                                                    1991-02-01

      A02T9   0000010000TIME AND EXPENSE                                                                    1991-02-01

      A020100 0000010035AXLE ASSEMBLY (FRONT drive axle), Replace                                           1991-01-01

      A020110 0000010097AXLE HOUSING (FRONT DRIVE), Replace                                                 2000-07-31

      A020120 0000010085DIFFERENTIAL carrier OR GASKET (FRONT DRIVING AXLE), R & R a                        2000-07-31

      A020120 0000020085nd/or Replace                                                                       2000-07-31

      A020145 0000010012PINION SHAFT OIL SEAL, Replace                                                      2000-07-31

      A020150 0000010080DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE  / REMOVED),                        2000-07-31

      A020150 0000020080 Repair                                                                             2000-07-31

      A020151 0000010060DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE  / REMOVED),                        2000-07-31

      A020151 0000020060 Repair                                                                             2000-07-31

      A020170 0000010004LOCKING HUBS (FRONT DRIVE AXLE), Replace                                            1991-01-01

      A020171 0000010007LOCKING HUBS (FRONT DRIVE AXLE), Replace                                            1991-01-01

      A020190 0000010028AXLE SHAFT AND/OR SEALS (FRONT DRIVE), Replace                                      1991-01-01

      A020190 0100010008U-joint, Replace                                                                    1991-01-01

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

        • Ver 9.01 can I get the second and third lines of the description?
          kbeaton _
            • Standard Repair Time Schedule Table for BSVs **

          OUTPUT FILE    SRT_BSV_DATA.TXT RECORD LAYOUT

          Columns        Field Description

                1        MODEL BYTE

              2-3        GROUP CODE

              4-7        OPERATION CODE

                8        ENGINE BYTE

             9-10        ADD-ON CODE

            11-14        SEQUENCE NUMBER

            15-18        TIME ALLOWANCE

            19-78        OPERATION DESCRIPTION

          79-102        SPACES

          103-112        AVAILABLE DATE

            • Ver 9.01 can I get the second and third lines of the description?
              kbeaton _

              I just need to part number as one unit, not broken out.

               

              Sorry for the multiple posts, just trying to make sure I have this clear...

               

              Kelvin

              • Ver 9.01 can I get the second and third lines of the description?
                Grant Perkins

                ** Standard Repair Time Schedule Table for BSVs **

                OUTPUT FILE SRT_BSV_DATA.TXT RECORD LAYOUT

                Columns Field Description

                1 MODEL BYTE

                2-3 GROUP CODE

                4-7 OPERATION CODE

                8 ENGINE BYTE

                9-10 ADD-ON CODE

                11-14 SEQUENCE NUMBER

                15-18 TIME ALLOWANCE

                19-78 OPERATION DESCRIPTION

                79-102 SPACES

                103-112 AVAILABLE DATE[/quote]

                 

                Kelvin,

                 

                Is the "11-14 Sequence Number" in effect a 'record' line number? Extra lines will have 02, 03, 04 and so on? (The last 2 sample lines have a further anomaly but we can get to that later.)

                 

                If so you could make the detail trap with an "01" at that position.

                 

                Then us a "guru" trap concept (I think - not yet tested) for an append template and use something that gives you the "02" as a predecing string - but it will need to be highly specific. Might require a little experimentation. Might not be possible, but worth a try.

                 

                Paint the field(s) that you want to the ight of the preceding string position and make it as multi-line field (to get 02, 03, 04 etc if they exist.) Can then slice and dice to get the separate fields if required.

                 

                That's the outline thinking for now. I may offer something different once I have played a little ....

                 

                HTH.

                 

                Grant

                  • Ver 9.01 can I get the second and third lines of the description?
                    Grant Perkins

                    Kelvin,

                     

                    It looks like some of the spacing in the lines has been lost in the report sample posted - is that indeed the case or are the field positions on the line in the report as you receive it somewhat variable? (despite the layout definition!)

                     

                    Grant

                      • Ver 9.01 can I get the second and third lines of the description?
                        mdyoung _

                        Kelvin,

                         

                        Based on your sample data and the specs supplied, your actual input file should reflect the following (correct me if I'm wrong):

                         

                        A02T6   0000010000TIME AND EXPENSE                                                                    1991-02-01

                        A02T7   0000010000TIME AND EXPENSE                                                                    1991-02-01

                        A02T8   0000010000TIME AND EXPENSE                                                                    1991-02-01

                        A02T9   0000010000TIME AND EXPENSE                                                                    1991-02-01

                        A020100 0000010035AXLE ASSEMBLY (FRONT drive axle), Replace                                           1991-01-01

                        A020110 0000010097AXLE HOUSING (FRONT DRIVE), Replace                                                 2000-07-31

                        A020120 0000010085DIFFERENTIAL carrier OR GASKET (FRONT DRIVING AXLE), R & R a                        2000-07-31

                        A020120 0000020085nd/or Replace                                                                       2000-07-31

                        A020145 0000010012PINION SHAFT OIL SEAL, Replace                                                      2000-07-31

                        A020150 0000010080DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED),                         2000-07-31

                        A020150 0000020080 Repair                                                                             2000-07-31

                        A020151 0000010060DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED),                         2000-07-31

                        A020151 0000020060 Repair                                                                             2000-07-31

                        A020170 0000010004LOCKING HUBS (FRONT DRIVE AXLE), Replace                                            1991-01-01

                        A020171 0000010007LOCKING HUBS (FRONT DRIVE AXLE), Replace                                            1991-01-01

                        A020190 0000010028AXLE SHAFT AND/OR SEALS (FRONT DRIVE), Replace                                      1991-01-01

                        A020190 0100010008U-joint, Replace                                                                    1991-01-01

                        /CODE

                         

                        If this is accurate, one way to tackle this is to trap all lines as the detail and create a summary that will basically give you a distinct listing of the part number and its available date.

                         

                        In my tests, I trapped the detail using the dash marks of the available date column. I defined the part number and available date fields. Created a new summary by placing the Part number and available date field in the KEY section, and since an aggregate column is required, I placed "count" in the MEASURE section.

                         

                        Here are the results of the summary:

                         

                        PartNum         AvailDate        Count[/B]

                        A020100        1991-01-01          1

                        A020110        2000-07-31          1

                        A020120        2000-07-31          2

                        A020145        2000-07-31          1

                        A020150        2000-07-31          2

                        A020151        2000-07-31          2

                        A020170        1991-01-01          1

                        A020171        1991-01-01          1

                        A020190        1991-01-01          2

                        A02T6          1991-02-01          1

                        A02T7          1991-02-01          1

                        A02T8          1991-02-01          1

                        A02T9          1991-02-01          1

                        /CODE

                         

                        Now if you need to export it to somewhere, you can just export the summary view. If the "count" column doesn't bother you, then this solution will probably work for you.

                         

                        Hope this helps.

                         

                        Thanks,

                         

                        Micheal

                      • Ver 9.01 can I get the second and third lines of the description?
                        kbeaton _

                        Hi Grant and Micheal,

                         

                        Yes I've confirmed that 11-14 is a "SEQUENCE NUMBER".

                         

                        I also need "all" the description...

                         

                        I've used Monarch some about 10 years ago, so any help would be very much appreciated!

                         

                        Thanks

                         

                        Kelvin

                          • Ver 9.01 can I get the second and third lines of the description?
                            mdyoung _

                            As a heads up, I'd be careful using the sequence number to trap for first entry because if you look at the following lines in your data, the sequence numbers (11-14) are the same.

                             

                            A020190 0000010028AXLE SHAFT AND/OR SEALS (FRONT DRIVE), Replace                                      1991-01-01

                            A020190 0100010008U-joint, Replace                                                                    1991-01-01

                            /CODE

                             

                            Thanks,

                             

                            Micheal

                      • Ver 9.01 can I get the second and third lines of the description?
                        mdyoung _

                        Kelvin,

                         

                        After studying the sequence number, I noticed that if it's repeated in the second line, there's an 01 in the Add-On Code position. Hopefully, this occurs anytime the sequence numbers repeat. If so, you can probably use this solution.

                         

                        1. Trap your detail by specifying 000001 starting with position 9. This will only look for an add-on code of 00 and a sequence number of 0001.

                        2. Define the part number and available date fields.

                        3. Starting with position 19, define your description field with a length of 60.

                        4. On the Advanced tab of the description field properties, select the "None of the above" option in the "End Field On" section.

                         

                        This returns the following output:

                         

                        PartNum     AvailDate     Description[/B]

                        A02T6     1991-02-01     TIME AND EXPENSE

                        A02T7     1991-02-01     TIME AND EXPENSE

                        A02T8     1991-02-01     TIME AND EXPENSE

                        A02T9     1991-02-01     TIME AND EXPENSE

                        A020100     1991-01-01     AXLE ASSEMBLY (FRONT drive axle), Replace

                        A020110     2000-07-31     AXLE HOUSING (FRONT DRIVE), Replace

                        A020120     2000-07-31     DIFFERENTIAL carrier OR GASKET (FRONT DRIVING AXLE), R & R a nd/or Replace

                        A020145     2000-07-31     PINION SHAFT OIL SEAL, Replace

                        A020150     2000-07-31     DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED),  Repair

                        A020151     2000-07-31     DIFFERENTIAL Carrier Assembly (FRONT DRIVE AXLE / REMOVED),  Repair

                        A020170     1991-01-01     LOCKING HUBS (FRONT DRIVE AXLE), Replace

                        A020171     1991-01-01     LOCKING HUBS (FRONT DRIVE AXLE), Replace

                        A020190     1991-01-01     AXLE SHAFT AND/OR SEALS (FRONT DRIVE), Replace U-joint, Replace

                        /CODE

                         

                        Thanks,

                         

                        Micheal