TCL Help

  • Creator
    Topic
  • #52681
    mike brown
    Participant

      Hi All

      I have HL7 Messages coming in the PV1:3 with double quotes in the fieldval, my code arguments work fine if the fieldval is empty or null, but it does not work since there are double quotes in the fieldval coming in.

      How can i adjust my code to filter, if double quotes show in the field i am filtering on.

      I have tried several combinations in the field val but nothing works yet.

      args:

      {SEGNAME PV1} {FIELDNO 3} {FIELDVAL {}}

      HL7 Message:

      PV1|1|E|””|3|||723435^XXXXI^XXX^””^^^^HL70010||””|EME||||2|||7135^XXXX^XXXXX^””^^^^HL70010|ED||SP||||||||||||||||H|||A||0|||20110456834|201104562359|||||

      any ideas

      thanks for looking

      Mike

    Viewing 2 reply threads
    • Author
      Replies
      • #75098
        Jim Kosloskey
        Participant

          Mike,

          You need to check the XlateInType for that field, if it has the value ‘null’ then the field actualy contains “”.

          I sent you a proc I have that does that as an example (of course you could just use that proc if you like).

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

        • #75099
          Jim Kosloskey
          Participant

            Mike,

            I just noted this is not about an Xlate. My reply (and the proc I sent) has to do with Xlate usage.

            I do not know the proc you are using but have you tried “”?

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

          • #75100
            mike brown
            Participant

              Hi Jim and thanks

              I had the slashes going the wrong way after checking my code again. it works fine..

              Yes i have tried “” in the fieldval of the args it still passes

              example

              {SEGNAME PV1} {FIELDNO 3} {FIELDVAL “”}

              mike

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