This content has been marked as final. Show 6 replies
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 %';