Search and Extract string into column

[qlikvw2019]

I have a column name "log" , it will have lots of details, i want to extract below 

....penalty: Low .....

OR

...penalty: Medium.....

I want to extract put the Low or medium in a separate column. Low/Medium will always be mentioned in the same format, right after

penalty:

[ponraj]

It would be great if you could share sample data

[AbhilashR · Accepted solution]

Hi @qlikvw2019, you could create a formula field with a logic that would look something like the below. It assumes column log will have penalty: Low of penalty: Medium as a string in it.

IF Contains([log],'penalty: Low') 
	THEN 'Low'
ELSEIF Contains([log],'penalty: Medium') 
	THEN 'Medium'
ELSE NULL()
ENDIF

If this doesn't work, please provide us a sample dataset for us to look at.