TCL Help

[mike brown]

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

Topic

[Jim Kosloskey]

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.

[Jim Kosloskey]

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.

[mike brown]

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

[Author]

Replies