Append PID:4 field value into PID:3 field in XLate

[Shu Chen]

Hello CLovertech.

I am using Cloverleaf V6.

I need to add PID;4 field value into PID:3 field in xlate. I am not sure how to do this. Any suggestions will be great!

for example

PID:3 |1^^^^MR~2^^^^SJH|

PID:4 |3^^^^HS|

expected Output will be

PID:3|1^^^^MR~2^^^^SJH~3^^^^HS|

thanks a lot

Topic

[Jim Kosloskey]

ITERATE through PID-3. Inside that ITERATE COPY the Counter you have associated with the ITERATE (say %f1) to your own counter (say %f99)

Now when the IITERATE of PID-3 is finished %f99 will have the value of the last occurrence of PID-3. You want PID-4 to go after that occurrence so MATH ADD =1 $%f99 –> $%f99 ( add 1 to %f99). Then COPY PID-4 to …PID.#3(%f99).

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies