extract values
my columns have values like P-DSO-12-2,P-DSO-20-7,PG-LFBGA-
80-6,P-LFBGA-81-1, PG-LFBGA-81-1, PG-TSSOP-28-1,PG-TSSOP-
28-1...etc..
I have to insert a new row inbetween these columns
wherever the value is fitting the best. Like say for an
example i have to insert a row with value "P-VQFN-64-
1" ...now this shoudl ideally check where "VQFN" is found
(the value after the 1st hyphen) and should be between :=
P-VQFN-56-1 & PG-VQFN-64-4; ie between 56 and 64.
which is the best logic to work it out...
any sugg will be highly appreciated
|