Need to get a part of a field

Can you explain your data in a little more details? For example, will the field always be delimited by semicolons and will the piece of the data that you want to extract always be in the same place?

If so, here is one way that might work for you.

Try changing it to just this:

set xlateOutVals

2]]

or if you have more than one input source, set the xlateInVals to a variable first

set clinic [lindex $xlateInVals 0]

set xlateOutVals list [lindex [split [lindex $clinic ;] 2]]

Hope this helps….

Tom

Odd. It works for me from a test script.

Put that code into a file called test.tcl and then run “tcl test.tcl” from the command line.

I do not recommend using “[split $xlateInVals ;]” because xlateInVals is a list variable. You never know when you’ll get data in that will bite you right on the tail. Always treat xlateInVals and xlateOutVals as list variable.

The semicolons may be screwing up the data. I’ll try it out in an xlate asap.

I created a test xlate. The code I provided with the data you provided works perfect for me. I used PV1.03 as a

I would agree with you in most cases, but since we are specifying a particular subfield PV2.23.[0], unless there are multiple source fields listed, then “[lindex $xlateInVals 0]” or $xlateInVals will return the same value.   I totally agree, I would be careful of using just the InVals designation if specifying only something like PV2.23.   That will bite you on the tail.

Incidentally, I have tried both Max’s code and my code in an xlate with the data provided and it should work for you Yamil.  If you are still having difficulty, maybe copy/paste some details showing us how you have it set up.

Thanks….Tom

Actually if the field has white space, then not specifying via a list reference may return only a part of the field/component.

It is always best to treat the xlate variables as lists.

The field in question did in fact have white space and by specifying the subfield designation (i.e. PV2.23.[0]) with $xlateInVals only, it still returned the whole subfield.   Is this something that should be concerning????

Interesting.

Since I always use the list reference, I can’tsay I have ever kicked the tires on inbound fields. Perhaps Xlate is not so sensitive with those.

However, I feel I would rather be safe than have to remember when to use list notation and when not to.

Using list notaitn has never caused me an issue – forgetting to use has caused me grief.

I’ve always been sure to use it on an OutVal.   As I’ve mentioned before, I never had a concern about using InVal alone so long as I was referencing a subfield and not an entire field.  That is curious.

I do have another question but I will start a new topic for it.

Yamil,

Try attaching the screen shot again

Tom

Can you paste the entire hl7 message, please?

It appears you have a space between the backslash (“”) and the semicolon.   Push them together like “;” and you should get your desired results.  

Just a note, when I put a space between them using the code, the first word I got in the destination field was “MEDICINE”.

Hope this helps…

Tom

Good eye, Tom.

Copy and paste the original PV2 segment into a message for us to see

Thanks…Tom

Yamil,

Is the Component Separator in MSH-2 a semi-colon ‘;’? Maybe all you need to do is select the correct field component.

Oh. You are using “:” and “;” as the HL7 field delimiters instead of the default “^” and “&”. So, you should be able to pull the field out without using any tcl code.

Data” :ADULT EMERGENCY MEDICINE;D;ADED;;;;XX:

Use “0(0).PV2(0).#23(0).[2]” as your inbound field.

Notice the “[2]”.

It looks like the ; semi-colon is the sub-component separator.

So you notation should be somehting like 0(0).PV2(0).#23(0).[0].[2].

The first [0] points to the component, the second [2] points to the sub-component.

Remove the tcl fragment. You don’t need it.