DTL Function Help

[JamesG]

Hi

I have been trying to work through DTL to split source field (a)  with value “AB12345” into “AB” and 12345 and insert source field (b) value of  “XYZ” to make it “ABXYZ12345” and assign the new value to target field, knowing that neither (a) nor (b) is fixed value. Is there DTL function that can do that? Using, SubString, I can extract the values but can't see a function available to insert "XYZ" 

Thanks,

James

[Steve Roselius]

James, just use the concatenate operator "_" (the underscore)

set output=SubString(S1)_"XYZ"_SubString(S2)

Cheers, Steve

On May 21, 3:07 pm, JamesG <berean...@googlemail.com> wrote:
> Hi
>
> I have been trying to work through DTL to split source field (a)  with

> value “*AB12345*” into “AB” and 12345 and insert source field (b) value of