I’m looking for a method of looking up a string in another datatable and finding a match. The string im using for the lookup is only a part of the string it needs to match with. Furthermore the matched string is not the desired value, it’s just the index of the row i want to return something else from.
You have several solutions, for example:
You can do a for each table and for each row in the table, you make a string.Contains in the column you want, and just save the index
or
you can filter the table with contains the word you want ,it will return the rows that contain the word you want and then with the filtered table you can see the id of the record and look in the original table to find out index