CSV File

  • Creator
    Topic
  • #49331
    Jared Miller
    Participant

      Is it possible to generate a CVS file from HL7 in Cloverleaf?

      I’m working with ver 3.8.1 on AIX.  Has anyone done this before?

    Viewing 4 reply threads
    • Author
      Replies
      • #61548
        John Hamilton
        Participant

          If you mean a comma separated file then I have would have to say yes.

          It can be done. But it has been a long time sense I have done anything with 3.8.  Was VRL available in 3.8?

          That would make it real easy.

          But if it does not then the answer is still yes, just a little more difficult. Use an FRL one field for each part of the HL7 message and do a copy with fields between for comma.

          I’m sure there are other ways to do it as well. Just like skinning a Rabbit.

          .

        • #61549
          Jared Miller
          Participant

            Yes, comma seperated file is what I’m referring to.  I typed CSV in the subject then mistyped it in the body…

            3.8 does in fact have VRL, and I have thrown together a quick test file to successfully generate my testvrl.csv file.  Thanks for your assistance!

          • #61550
            Jim Kosloskey
            Participant

              Jared,

              Just a little thing I like to do is to use tabs rather than commas for the field delimiters. Most systems can use any delimiter as long as they know what it is and I find tabs cause fewer issues in the long run.

              Be aware that just like HL/7, very few folks follow the delimited record rules closely and so some tweaking may be necessary.

              Jim Kosloskey

              email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

            • #61551
              Charlie Bursell
              Participant

                I think I ststed this before but there is an excellent CSV package in tcllib.  I think the latest version is 0.9 or something like that.  Googlr it for download

              • #61552
                Ed Mastascusa
                Participant

                  Jared,

                  we installed the csv 0.4 package in 5.3 (Tcl 8.3) and it works fine.  You need to have tcllib 8.3 or higher to install the package we used, so it could be possible that it won’t work in 3.8. I think 5.5 may already have the csv package pre-installed as it may come standard with more recent versions of the Tcl library.

                  hci@whippet(qprod):/home/hci>

                  $ tcl

                  tcl>package require Tcl

                  8.3

                  tcl>package require csv

                  0.4

                  tcl>set theLine [ list a b c 1 2.3 “4,5,6” ]

                  tcl>::csv::join $theLine

                  a,b,c,1,2.3,”4,5,6″

              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.