Pathcopy iterate question

[Gina Borden]

Here is my inbound ORC segment:

ORC|NW|1012^OrderID~1012^OccOrder_ID~1818^Order_ID|

I have a pathcopy on the ORC segment, but I need to iterate through the 2nd field, look for Order_ID, and put that number in the outbound ORC.2

This is what I have:

IF                2(0).0(0).ORC.00216(%f1).[1] eq =Order_ID

  COPY        2(0).0(0).ORC.00216(%f1).[0] -> 1(0).0(0).ORC.00216(0).[0]

Expected Outcome:

ORC|NW|1818|

Actual Outcome:

ORC|NW|1818^OrderID~1012^OccOrder_ID~1818^Order_ID|

I’m sure I am missing something, but I can’t figure out what it is.  Any help would be greatly appreciated.

Topic

[John Hamilton]

After you do the first pathcopy. Your field has all the data in it.

you need to go back to that specfic field and pathcopy @null to your field

Pathcopy @null 1(0).0(0).ORC.00216(0)

Then do your iterate and copy only the field you want.

[Gina Borden]

Perfect!

It worked like a charm.

Thanks for your help.

[Author]

Replies