Our goal is to send all 6 sub-fields if values are there; otherwise send “”. However, we can’t seem to access the sub fields. Also, the vendor would like us to take the 6 incoming fields evaluate the data, use a look-up table to map to a single character and put the single character in a designated output field of which there are 18 available fields.
The incoming values can be MRSA, ESBL, ESBL – ECOL, ESBL – KLOX, VRE, ROG:Other, R-BURCEP, and R – ECOL just to name a few.
Any help is greatly apprecited. Thanks, Sarah