Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Extract particular string(ABC-2673)

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 .

1 Solution

Accepted Solutions
sunny_talwar

May be try like this:

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

View solution in original post

4 Replies
sunny_talwar

May be try like this:

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

View solution in original post

sudeepkm
Specialist III
Specialist III

you can use

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

which will bring the text part after ': '

sunny_talwar

Check out the sample

Capture.PNG

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
Creator II
Creator II
Author

Thanks sunny t it started work .