Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I need to extract 3 new columns with their values from a string:
Project.ID='123',BOM='AB',Product.ID='55'
What is the best practise, thank you for your help!
Tom
Assume your sample:
Project.ID='123',BOM='AB',Product.ID='55'
is in the field str:
TextBetween(str, 'Project.ID=''', '''') as ProjectID,
TextBetween(str, 'BOM=''', '''') as BOM,
// etc
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Assume your sample:
Project.ID='123',BOM='AB',Product.ID='55'
is in the field str:
TextBetween(str, 'Project.ID=''', '''') as ProjectID,
TextBetween(str, 'BOM=''', '''') as BOM,
// etc
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Thanks @rwunderlich
I have this string:
ALTERNATIVE_NO=*^BOM_TYPE_DB=M^CONTRACT=LKP^GUIDELINE_NO=1^OPERATION_ID=4^PART_NO=3600009-620^ROUTING_REVISION=1^
and have this code:
TextBetween(KEY_REF, 'PART_NO=', null()) as Part_NO,
As result I am getting this value: 3600009-620^ROUTING_REVISION=1^
But I only need 3600009-620.
How can I get the right value in my code above?
Thank you, Tom
As below.
TextBetween(KEY_REF, 'PART_NO=', '^') as Part_NO