I may not have clearly defined what I have and what I want to create. I have 1 source file with 3 records in it, vrl format, delimited by a |. Example:
1235|this is an item||||xx456
4567|this is another item||||xx567
59688|this is a third item||||xx998
These data elements belong in various places in the CD1, 2, and 3 segments
I want 1 destination file, a batch file, with repeating groups of segments, except for MSH and MFI.
Example:
MSH|~^&||||||||
MFI|CDM||
CD1|1235||||
CD2|||||
CD3|||||
CD1|4567||||
CD2|||||
CD3|||||
CD1|59688||||
CD2|||||
CD3|||||
My CD1,2,3 is a repeating group in my message, so this part is fine. But I don’t want multiple messages, therefore I don’t want more then 1 MSH and MFI.
If anyone has done anything like this, I appreciate your help. But I can’t use tcl yet, I don’t know it enough, so I need to figure it out within the gui.
Thanks.