I am trying to create three new columns with just the drug name(Red), and two columns with the NDC(Green) numbers.
There is a variable char# count
Is this possible to do?
I have included an excel file with two different sets of data.
Reorder number and drug name are veritable character length.
LIB CONNECT TO 'pharmoresql production (pharmore_rwinkel)';
UPPER (ChangedBy) as ChangedBy,
QL SELECT ID,
ere ChangedOn > '2015-1-1'
and Upper(Msg) like '% NDC FROM %';
Solved! Go to Solution.
Use the below to get the required columns
TextBetween(Msg,'(',')') as Supplement,
SubField(SubField(Msg,'NDC from ',2),'"',2) as FromNDC,
TextBetween(SubField(SubField(Msg,'NDC from ',2),'to',2),'"','"') as ToNDC ;
Qlik manual is the best place to start with