Clovertech

extra "" pair shown at string defined fields HL7 O

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › extra "" pair shown at string defined fields HL7 O

  • Creator
    Topic
  • September 10, 2010 at 4:34 pm #51984
    Hongle Sun
    Participant

      Hello, I am trying to do my first VFL configuration, which translates a CVS file to hl7 with xlate file. However, I see string defined fields in HL7 outbound message have extra “”,such  as, patient name PID 5,  outbound field data shows like “Lastname, FirstName”. I understand that “” roots from the cvs files, but I would like to get rid off

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • September 10, 2010 at 5:19 pm #72591
        Jim Kosloskey
        Participant

          We are on Cloverleaf 5.6.

          What this is: following the CSV ‘standard’ a field which has a field separator as part of the data is enclosed in “.

          I hoped that by defining the ‘Escape Pair” in teh VRL configurator the Xlate would handle this automatically – it does not (at least I could not get it to handle it).

          So I used a xltp type proc we have to trim teh ” off of both ends of the field inside the Xlate.

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • September 10, 2010 at 6:25 pm #72592
          Hongle Sun
          Participant

            Thanks Jim. Would you mind asking the etra quesiton regarding the fileset-ftp. I’m just wandering if i can use the protocol to get file in window? how?

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.