Extract new fields from a string

[TomBond77]

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

[rwunderlich · Accepted solution]

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

[TomBond77]

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

[BrunPierre]

As below.

TextBetween(KEY_REF, 'PART_NO=', '^') as Part_NO