Help with concatenating within Xlate

[Tom Arrowsmith]

I am trying to concatenate 3 subfields together, two from one field and the third from another …. and then write them to a different (empty) field.

The total length of the resulting string will be at least 4 characters – but could be as long as 12 or so….

example: PV1-4.2 = ED, PV1, 4.3 = C, PV1-5.1 = C

concatenate together should = EDCC

My problem is whatever subsequent field I try to store this value in will only accept the first three characters – no matter that the variant allows for more. (I suppose it could be the first and third, in this case – but unlikely)

One other inportant fact is that I am creating the value in the PV1-5.1 just previous to this in the Xlate. Is that the issue?

Thanks!

Topic

[Jim Kosloskey]

Tom,

Make sure your address path specification for PV1-5.1 is correct. You could be pointing to a null field.

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

[James Cobane]

Tom,

When you say you are “creating the value in the PV1-5.1 just previous to this in the Xlate”, are you saying that the inbound doesn’t have a value in PV1-5.1, but you are mapping a value to the outbound PV1-5.1?

[Tom Arrowsmith]

Thanks, James….

I actually just figured that out this morning – then saw your reply. That’s exactly it – all is well now.

Thanks to you and Jim K. for your responses.

Tom

[Author]

Replies