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

    floating trap problem

    Mriley7212 _

      Hello, This time my problem is with data in a liune that has varying number of characters. See the example below:

      AC,32577,NEGREENSCA,NEW ENGLAND GREENSCAPES, INC.,,,2010-09-09T00:00:00,3533,0                      

      ,2012-09-10T00:00:00,VR 00003628-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,408

      ,2012-09-10T00:00:00,VR 00003629-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125

      ,2012-09-10T00:00:00,VR 00003630-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125

      ,2012-09-10T00:00:00,VR 00003605-001,,AA.7110.430,PK. - LANDSCAPING,,0,1000                         

      ,2012-09-10T00:00:00,VR 00003611-001,,AA.7110.430,PK. - LANDSCAPING,,0,1875                         

      The area I need starts with PROPERTY MAINTENANCE: - I have tried the floating trap using the comma as my start but there are many commas and I have tried converting the data to PRN, PDF, TXT, and Excel.

       

      Issue 2 -When I bring it in with Excel I cant get to set up any templates to move  the data around. I appreciate any help here.

       

      Thanks,

       

      Mike

        • floating trap problem
          RalphB _

          Hi Mike,

           

          This file appears to be a comma delimited file which would lend itself to be opened as a database instead of a report.

           

          I took your sample and was able to open it successfully as a database in Monarch without converting it to Excel or any other type of file.

           

          Give that a try and let us know how it fared.

           

          HTH.

            • floating trap problem
              Olly Bond

              Hello Mike,

               

              AC,32577,NEGREENSCA,NEW ENGLAND GREENSCAPES, INC.,,,2010-09-09T00:00:00,3533,0

              ,2012-09-10T00:00:00,VR 00003628-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,408

              ,2012-09-10T00:00:00,VR 00003629-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125

              ,2012-09-10T00:00:00,VR 00003630-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125

              ,2012-09-10T00:00:00,VR 00003605-001,,AA.7110.430,PK. - LANDSCAPING,,0,1000

              ,2012-09-10T00:00:00,VR 00003611-001,,AA.7110.430,PK. - LANDSCAPING,,0,1875 /CODE

               

              I'm assuming that the first line is some sort of append record with customer details, and that the other lines are the detail lines of the work done for that customer? In which case, reading it as a database won't help, as you lose the ability to specify different templates for the different types of line.

               

              What if you trap on NNNN.NNN, - that's picking up from the 7111.430 data which appears just before the data you want?

               

              Best wishes,

               

              Olly