Hi,
I want to extract the bin values from the rows and store in the list.
For example-
BIN = "B" 8 "Bad Bump" -> I want to extract letter "B" from the string and store in the list
BIN = "P" 6153 "PCM" -> I want to extract letter "P" from the string and store in the list and likewise for all the rows containing bin
Here is what I tried so far. It only extracts the row 13
Names Default To Here( 1 );
Clear Globals();
Clear Log();
dt = current data table();
asa = dt << Get Rows Where (Contains(as column(3), "BIN") & Contains(as column(3), "NULL") == 0);
binlist = {};
it = asa[1];
for(k =1, k<= Nitems(asa), k++,
Insertinto(binlist, db_test:Bins[asa])
);
binvaluelist= {};
n = for (i = it, i <= nitems(asa), i++,
newlist = dt:Bins[i];
word_list = words(newlist, "\!"\!"");
insertinto(binvaluelist, word_list);
);
