Help nulling out a field that repeats

[Tom Arrowsmith]

Hi,

I’m trying to null out an MSH-4 that usually has a value of “C~L” and then hardcode the value “Cornwall”. When I null out MSH-4 and hardcode “Cornwall” the result is “Cornwall~L”

Can someone tell me how to get the end result of simply “Cornwall” in that field?

Much thanks ahead of time!

Tom

Topic

[Tom Rioux]

Try doing a PATHCOPY on the field where your inbound source is @null and your outbound source is MSH.4

Then do a COPY on the field where inbound source is =Cornwall and your outbound source is MSH.4

Tom

[Max Drown (Infor)]

Here’s how you can do it use addresses for example:

COPY @NULL 1(0).PV1(0).#7(0).[0]

COPY @NULL 1(0).PV1(0).#7(1).[0]

Notice the #7(n).

-- Max Drown (Infor)

[John Mercogliano]

Tom,

  The problem you are having is that the ~ represents a repeating field in HL7 but MSH:4 at least up to 2.4 is not defined as a repeating field so you will have to hardcode Max’s solution if you don’t want to create a variant as the GUI won’t show the repetition when you select the field.

COPY @NULL 0(0).MSH.#4(0)

COPY @NULL 0(0).MSH.#4(1)

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Tom Rioux]

Next time I will think it through further before answering.  It didn’t dawn on me to check to see if that was a repeating field.

[Author]

Replies