What I’m looking to do is filter based on doctors that have been CC’ed on a specific result by looking up each physician in a table. If a physician ID has been found in the table, it no longer needs to look up any others, the result will be sent. However, if a physician is not found in the table, the message will be killed.
The CC physicians come out in TXA-23 in the following format:
53221^SMITH, D CHRISTOPHER~55649^SMITH, L JOHN~55329^SMITH(NS), M RYAN~55649^SMITH, L JANE
Only physician numbers exist in our table, so I need to loop thru the field and determine if a number is in our table. If it is, the message continues, otherwise it will be killed.
Thanks for the help!
Josh