Extract particular string(ABC-2673)

[srinivasa1]

Hi

Need help on search or extract particular string(ABC-2673) that comes dynamically from field  see  below example on same

Fields value as below

Outgoing link to : ABC-2673
Outgoing link to : DDD-2656
Outgoing link to : KKK-2456

What I’m looking below value from above fields

ABC-2673
DDD-2656
KKK-2456

Advance thanks for any best way to handle this in ETL script .

[sunny_talwar · Accepted solution]

May be try like this:

SubField(FieldName, ' : ', -1) as FieldName_New

[sudeepkm]

you can use

subfield(yourtextfield,' : ',2) as newfield

which will bring the text part after ': '

[sunny_talwar]

Check out the sample

Script:

Table:

LOAD *,

  SubField(FieldName, ' : ', -1) as FieldName_New

INLINE [

    FieldName

    Outgoing link to : ABC-2673

    Outgoing link to : DDD-2656

    Outgoing link to : KKK-2456

];

[srinivasa1]

Thanks sunny t it started work .