Hi,
You could use Tcl to pre or post process your format. I have done something similar and used a combination of inbound TPS to preformat the data, an Xlate on a HRL (built up on vrl’s with a repeating block) followed by an outbound TPS to final format the record.
The HL7 method also works and I’ve used that on other occassions. I look at the data first and see which is the best fit but sometimes its not obvious until you’ve done both:-)
Regards
Garry
