6 Replies Latest reply: May 15, 2014 10:03 AM by ccribbs _ RSS

    Copy values

    ccribbs _

      I have a report that i receive in an excel file and convert to csv.  I open the report in V9 as a database and I'm trying to copy values down into null fields, but when I click on the field properties, this is not an option, I have no advanced tab and on the general tab i don't see Verify: or Empty Cells:.  Is there another way to copy value from previous record?  In the sample below, I would be trying to copy TLP down through all records beneath until the next TLP.  The second occurence of the three letters is a subtotal line.

       

      MNT     J00003730924     07/12/2008

      MNT          

      RHT     54264246     07/14/2008

      RHT          

      SRV     71419397     07/30/2008

      SRV          

      TLP     65406887     07/22/2008

           65406894     07/03/2008

           65406943     07/31/2008

           70506913     07/22/2008

           70506914     07/24/2008

           J00002618500     07/29/2008

           J00002628776     07/12/2008

           J00002628778     07/12/2008

           J00002628796     07/31/2008

           J00002628799     07/31/2008

           J00002628800     07/19/2008

           J00002628827     07/19/2008

           J00002628848     07/23/2008

           J00002628849     07/12/2008

           J00002628850     07/12/2008

           J00002632049     07/22/2008

      TLP          

                 

      /CODE

        • Copy values
          joey

          I think the copy previous values option is available only when dealing with reports.  Could you convert this to a text file from Excel?

            • Copy values
              ccribbs _

              I did convert to text, but it makes quite a messy report where the first line includes the company name and number in 1 field but no other lines include this data.  Now I don't have a clue of where to begin to make a template to trap the data.

               

              01771 - XYZ Wxyz Inc            Mnt     J00003730924    07/12/2008      1n4ba41e88c827154       S       $59.00

                              Mnt                                     $59.00                                                

                              Rht     54264246        07/14/2008      1n4al21e88n544185       S       $34.00                

                              Rht                                     $34.00                                                

                              Srv     71419397        07/30/2008      1n4al11d45c342923       Pc      ($116.01)             

                              Srv                                     ($116.01)                                             

                              Tlp     65406887        07/22/2008      1n4al24e98c103527       Pc      ($45.20)              

                                      65406894        07/03/2008      1n4al21e17n484118       Pc      ($46.77)              

                                      65406943        07/31/2008      1hgcm56603a004754       Pc      ($47.53)              

                                      70506913        07/22/2008      3n1ab61e98t725531       S       $55.00                

                                      70506914        07/24/2008      1n6ra0zd98n357185       S       $55.00                

                                      J00002618500    07/29/2008      1n4ba41e28c823178       Pc      ($50.88)              

                                      J00002628776    07/12/2008      3n1ab61e98l725531       S       $55.00                

                                      J00002628778    07/12/2008      1n6ba07d98n357185       S       $55.00                

                                      J00002628796    07/31/2008      1n6ba06a18n355745       S       $55.00                

                                      J00002628799    07/31/2008      1n6ad07u68c411010       S       $55.00                

                                      J00002628800    07/19/2008      1n6ad07u08c441023       S       $55.00                

                                      J00002628827    07/19/2008      1n6ad07u28c425356       S       $55.00                

                                      J00002628848    07/23/2008      1c3lc56k57n546885       S       $55.00                

                                      J00002628849    07/12/2008      1n4ba41e88c827154       S       $55.00                

                                      J00002628850    07/12/2008      1gcec14x16z122574       S       $55.00                

                                      J00002632049    07/22/2008      1n6bd06t48c449056       Fc      ($55.00)              

                              Tlp                                     $359.62                                               

              /code

               

              Any help is appreciated.

                • Copy values
                  joey

                  I can think of a few ideas, but they aren't the easiest.  Is this the way the Excel spreadsheet looks?  One option is always to manually adjust the data a little to make it easier in the end.

                    • Copy values
                      ccribbs _

                      In the excel file each field is its own column.  This is something i would be doing monthly, so I'm trying to stay away from manually adjusting the file.

                        • Copy values
                          Joe Berry

                          If you take the csv data from Monarch and write it to a fixed text format, it will be formatted as it appears in Monarch.  Then take that data and bring it into Monarch as a report. That will open up the ability to copy from the value above.  Makes an extra step but gets you the data you need in an automated fashion.

                           

                          Hope that helps.

                          Joe