Xlate Question

Going thru spec meetings with Cerner and McKesson for MSPQ issues.  Cerner sends their MSP via a Z segment in one recurring field with the question number (Q1, Q2, etc) and the answer to that question.  McKesson has a Z segment where each MSPQ is assigned a specific field assigned to it.  So the structure is as follows:

Cerner – ZQA|||Q1^Black Lung^Y~Q2^10/14/1972~Q3^…..etc.

McKesson – ZPM|Y|10/14/1972|N|……etc

The question is has anyone ever done a xlate or written any tcl that could look thru the recurring field for the Q1 and then map that to the ZPM field McKesson wants it in?  I’ve mapped recurring field to recurring field before, but never a recurring field to different fields in a segment.

Any questions or ideas??