2 Replies Latest reply: May 15, 2014 9:58 AM by Steve Caiels RSS

    line slippage in original documents

    PJT _

      Our legacy system regularly throws lines out of pattern. Its pretty awful to go through the spreadsheet afterwards trying to identify which lines didnt transfer across. An example below:

       

      C0165  CERAMICS LTD 2364.96 0.00       

      D001

                                                   5      DECORACI  1779.72  25.00          

      D0075  THE0DENB  1918.99 391.54       

      E0006  GEORGE01     0.00   0.00               

      E0029  ENERGIZE  19.34

        37.10     

                                                        here two lines have jumped a) at the fourth digit of the second record and b) again at the last field of the last record. Has anyone any ideas how this might be overcome or any suggestions on the easiest way to edit to source document so that it extracts out easier. Most of the source documents worked with are formatted for wide listing paper.

      Thanks in aniticpation

      PJ

        • line slippage in original documents
          Grant Perkins

          Hi PJT,

           

          My first response is to suggest checking the file for spurious Carriage Return and Line Feed characters at the points where the lines split. (I think the post has lost a little in the posting so not sure exactly what you get for format). You may be able to use the MSRP utility to correct the file before submitting to Monarch - but then again maybe not.

           

          Plan B (based on what I can Cut and Paste from the posting)  would be to trap on the Alpha and 3 numeric at the beginning of a detail line, make the entire line a single field and a multi line field as well using "end field on" - 'minimum action'. Again this makes some assumptions about the format of the data row.

           

          Then split it up again as required, probably using LSPLIT or RSPLIT functions and so on.

           

          The section of report presented does not seem to have a regular pattern (space delimited fields?) and the second line/3 line split, when dealt with as described, includes an extra space in the number. This maybe just an edit problem? If it is a real problem we will need to derive a way to work around it.

           

          There may be other approaches but I would like to know if the real output is exactly as posted before looking into them. In this case it is important to know.

           

          Hope this helps.

           

          Grant

           

            Originally posted by PJT:

          Our legacy system regularly throws lines out of pattern. Its pretty awful to go through the spreadsheet afterwards trying to identify which lines didnt transfer across. An example below:

           

          C0165  CERAMICS LTD 2364.96 0.00       

          D001

                                                       5      DECORACI  1779.72  25.00          

          D0075  THE0DENB  1918.99 391.54       

          E0006  GEORGE01     0.00   0.00               

          E0029  ENERGIZE  19.34

            37.10     

                                                            here two lines have jumped a) at the fourth digit of the second record and b) again at the last field of the last record. Has anyone any ideas how this might be overcome or any suggestions on the easiest way to edit to source document so that it extracts out easier. Most of the source documents worked with are formatted for wide listing paper.

          Thanks in aniticpation

          PJ /b[/quote]

           

          [size="1"][ July 09, 2003, 08:11 PM: Message edited by: Grant Perkins ][/size]

          • line slippage in original documents
            Steve Caiels

            Hi PJ,

             

            Try the "Ignore unused Print Control characters" under Options->Input

             

            This can also happen if the legacy output is tab delimited (or has been passed through Excel).  If you have a choice, select fixed width or space delimited.

             

            Cheers

            Steve