e.g. "jaslyn meranda; papi kiloso, anis; mervin landan (mer)"
Then i have a datatable which one of the columns is the names, I need to check if the rows belongs in the string of names. If it belongs, then filter into a new datatable, if not it’ll just skip. the names might be in different arrangement, in the datatable
e.g. papi kiloso anis (without the comma), or kiloso papi anis
Hi. Umm.
The datatable will be from an excel where there are few columns, 1 of it is the “name” column. The string of names will be given from somewhere else.
Here. The names might be in different format, but as long as the string given contains the name, it should be copied to a new datatable with the other details in that row.
Hi @NIVED_NAMBIAR , sorry i dont quite understand this part, can you explain please?
If there are more than 100 rows and 2-3 sheets in each excel, wil this slow down the process? Is it possible to do something with filter datatable instead?
name in excel is splitter and stored in array , it is actually through all element in array and checking whether the name string contains the element of the array of particular row
If it is yes
Then it write the data into row of datatable dt2
Sorry there is no use of assign variable row1= row,. I forget to delete it . Sorry u delete that part
Ur next question, I think using filter operation we May not get it