6 Replies Latest reply: May 15, 2014 10:13 AM by Mriley7212 _ RSS

    Amounts in various locations on a line

    Mriley7212 _

      I converted an Excel file to text and the columns are not in a vertical line. So when I set the trap it only picks up a % of the targets.

       

      I also have a set of data that has variable invoice lines. Having trouble capturing all the data here also.

       

      Mike

      [SIZE=3][/SIZE][/FONT]

      35158   00M&TBANK      M&T BANK                        3/15/2012       $2,963.00                                /FONT

      [SIZE=3][/SIZE][/FONT]

      12-Mar  VR 00006774-001         AA.1325.200     TREASURER, EQUIPMENT                    $565.50                  /FONT

      [SIZE=3][/SIZE][/FONT]

      12-Mar  VR 00006776-001         AA.1325.200     TREASURER, EQUIPMENT                    $565.50                  /FONT

      [SIZE=3][/SIZE][/FONT]

      12-Mar  VR 00006777-001         AA.3120.200     POLICE - EQUIPMENT                      $1,832.00                /FONT

      [SIZE=3][/SIZE][/FONT]

                                                              $2,963.00                                               /FONT

      [SIZE=3][/SIZE][/FONT]

      35320   00M&T BANK      M&T BANK                        4/12/2012       $565.50                                  /FONT

      [SIZE=3][/SIZE][/FONT]

      12-Apr  VR 00006916-001         AA.1325.200     TREASURER, EQUIPMENT                    $565.50                  /FONT

      [SIZE=3][/SIZE][/FONT]

                                                              $565.50                                                 /FONT

      [SIZE=3][/SIZE][/FONT]

      32145   0SCHMIDTS0      SCHMIDTS , INC.                 7/15/2010       $188.56                                  /FONT

      [SIZE=3][/SIZE][/FONT]

      10-Jul  VR 00003306-001         FF.8340.410     WATER - TRANSM & DISTR - SCHMIDT'S                      $71.14   /FONT

      [SIZE=3][/SIZE][/FONT]

      10-Jul  VR 00003306-002         FF.8340.410     WATER - TRANSM & DISTR - SCHMIDT'S                      $117.42 /FONT

      [SIZE=3][/SIZE][/FONT]

        • Amounts in various locations on a line
          Grant Perkins

          A couple of quick questions.

           

          Did you need to convert the Excel file to text or could you read it directly as a database and still get the analysis you want?

           

          Have you considered converting it do a delimited text file or, perhaps better in this case, a file with fixed width columns?

           

           

          Grant

          • Amounts in various locations on a line
            Data Kruncher

            Hi Mike, and welcome to the forum.

             

            Does the regular formatted presentation in Excel look like it might be easier to tackle with Monarch than your exported text file does?

             

            If so, consider exporting the Excel worksheet to a PDF file or perhaps an XPS file, and using Monarch on that output.

              • Amounts in various locations on a line
                Mriley7212 _

                I just started the PDF

                10-Dec VR 00004057-001 AA.1325.200 TREASURER, EQUIPMENT $100.00

                10-Dec VR 00004056-001 AA.3120.200 POLICE - EQUIPMENT $1,832.00

                10-Dec VR 00004058-001 AA.3120.200 POLICE - EQUIPMENT $11,243.00

                10-Dec VR 00004059-001 FF.8320.200 WATER-PUMP-TEST WELLS $6,857.00

                $20,032.00

                AC 33067 00M&T BANK M&T BANK 1/12/2011 $565.50

                11-Jan VR 00004252-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50

                $565.50

                AC 33213 00M&T BANK M&T BANK 2/9/2011 $3,770.75

                11-Feb VR 00004485-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50

                11-Feb VR 00004486-001 AA.1325.400 TREASURER - CONTRACTUAL $565.50

                11-Feb VR 00004404-001 CL.8160.200 REFUSE & GARBAGE EQUIPMENT $2,639.75[/code]

                 

                Like that?