Concat in Xlate

[Femina Jaffer]

Does anyone remember what the syntax to append a “P” to a field in the destination using an xlate?  For example, I need to append “P” to PID2 and then copy to destination PID2.   Please advise, my mind is just blank.

As an FYI we have CL 6.1.1.

Thanks,

Femina

Topic

[Jim Kosloskey]

CONCAT is the Action.

In the Source put the fields (including literals if that is what you want) you want concatenated together and the field to receive the concatenation in the Destination.

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

[Jim Kosloskey]

Oh and if one of the fields is a destination field just make sure there is a tilde (~) a the front of that field path in the Source.

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

[Femina Jaffer]

Thanks Jim, that’s what I thought.  Can you provide an example, cause its still not working.  Here is what I have:

Action Concat:

Source:  1(0).STF(0).#2(0).[0]=P

Destination:  @tmp

I also tried adding the tilde in front of the source, no luck.

[Femina Jaffer]

Jim,  I was finally able to get this too work.  Thanks for your help!

Here is what I did:

Action: CONCAT

Source:  1(0).STF(0).#2(0).[0]  /** =P in the next line

            =P

Destination: @tmp

Then I did a COPY using the tmp variable and copied to the destination field.

FJ

[Author]

Replies