CONCAT

[Paul Sullivan]

Site wants to have second phone number field in PID-14 added to first phone field in PID-13 to look like an iteration. I tried CONCAT on the source side:

0(0).PID.#13(0)

=~

0(0).PID.#14(0)

this messed up some of the PID-14 sub-fields.

Next I tried to do a PATHCOPY for PID-13 and PID-14 and sent them to a variable as well as the ~ to a variable. then tried CONCAT like

@pid13

@tilde

@pid14

This worked worse.

Suggestions?

Topic

[Jim Kosloskey]

Paul,

If the destination field is defined as a repeating field simply COPY (or PATHCOPY) the source field to the second occurrence of the destination field using field repetition notation something like this:

0(0).PID.#14(1)  <– Note the 1 in the field repetition to denote the second repetition of the field.

The Xlate will provide the tilde.

If the field is not defined as repeating in the outbound variant, change it to repeating, Reconfigure your Xlate, then do the above.

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

[Paul Sullivan]

Thanks Jim, that did the trick.

[Author]

Replies