DSXchange

Hi,

I need some advice on following data extract.

In the source there is a field with following data format

A12-ABCDEFG123456 ^ 12345678

Now I want only the part ABCDEFG123456

I have tried Field(Mystring, "-", 1) which will give me result = A12 if I use Field(Mystring, "-", 2) it will give me result = ABCDEFG123456 ^ 12345678

Please advice me how to get only ABCDEFG123456

Thanks.

Tlam

how about

Step 1
A1= Field(Mystring,'^',1) which gives result=A12-ABCDEFG123456
then
A2=Field(A1,'-',2) which gives result=ABCDEFG123456

use stage variables to achieve this

Thanks
Paddu

For something that simple, you could nest the Field functions. The MatchField() function can also be used here.

[quote="ray.wurlod"]For something that simple, you could nest the Field functions. As Ray suggested nested field functions is good .

Ray's function is resulting 12345678

Probably below is the one you are looking ,which results ABCDEFG123456

Field(Field(InLink.MyString, "^", 1, 1), "-", 2, 1)

Edited my previous post to correct typo.

Thanks guys for the advice :D