topic Extract particular string(ABC-2673) in QlikView

Extract particular string(ABC-2673)

srinivasa1 — Fri, 30 Sep 2016 19:01:15 GMT

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 — Fri, 30 Sep 2016 19:02:51 GMT

May be try like this:

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

sudeepkm — Fri, 30 Sep 2016 19:04:13 GMT

you can use

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

which will bring the text part after ': '

sunny_talwar — Fri, 30 Sep 2016 19:04:55 GMT

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 — Fri, 30 Sep 2016 19:54:37 GMT

Thanks sunny t it started work .