2 Replies Latest reply: May 15, 2014 9:57 AM by D Darrow RSS

    Reading or converting .DIF to a usable format

    D Darrow

      I have files I'd like to import into MS access however they are in a .dif format/extention.  Doesn't look like Monarch supports this file format.

       

      Obvious answer is to have the program that generates or exports the data changed to output a delimited file that is readable by Monarch or Access.

       

      Other option (manual) would be to pull the files up in Excel and then do a file save as to .txt.

       

      Any better ideas or suggestions?  Again, perhaps not a direct monarch question per se but would appreciate any help.

       

      Thanks

        • Reading or converting .DIF to a usable format
          Grant Perkins

          Daran,

           

          I have a feeling that the .dif extension is registered for exclusive use by a single application, so he content of a .dif file could be any format.

           

          The only file I can find on my system seems to relate to the Copernic Desktop Search program and had a default association with Excel, though Excel could not recognise it.

           

          IIRC .dif files on UNIX system I have used were often file comparison program outputs.

           

          What is the source program for this file and does that information offer any clue about the best way to access it? What do you see if you open Monarch and then try to open the file?

           

           

          Grant

          • Reading or converting .DIF to a usable format
            D Darrow

            Grant-

             

            Thanks for the reply...sorry for my delay.  Yes, the extention is probably 'registered' with Excel.  The data happens to be coming from an AS400 and yes, I can change the output format going forward, was just trying to cheat and see if there was an easy way to use the existing historical files without having to re-run and re-download.

             

            No additional reply is needed - just wanted to make sure there wasn't a easy answer.  Below is some of the 'raw' data/contents of a DIF file...

            TABLE

            0,1

            ""

            VECTORS

            0,18

            ""

            TUPLES

            0,721

            ""

            DATA

            0,0

            ""

            -1,0

            BOT

            1,0

            "OHCO"

            1,0

            "OHUFL3"

            1,0

            "OHCUNO"

            1,0

            "OHOREF"

            1,0

            "OHOBNO"

            1,0

            "OHORNO"

            1,0

            "OHPONO"

            1,0

            "OHOBDH"

            1,0

            "OHOBDE"

            1,0

            "OHBATN"

            1,0

            "OHTOTA"

            1,0

            "OHOPNA"

            1,0

            "OHCLSH"

            1,0

            "OHCLSE"

            1,0

            "OHDESC"

            1,0

            "OHSMAN"

            1,0

            "OHUFL1"

            1,0

            "OHTRAN"

            -1,0

            BOT

            1,0

            "  760"

            1,0

            "745"

            1,0

            "     745154906"

            0,15366051

            V