Sorry if this is a silly question but I am still learning.
I have a queue item coming into a process. I am going to cycle that item thru a datatable to see if there is a match.
Problem is, the item string coming in does not match the string I need to compare to in the datatable. For instance, the queue item comes in as “Zip” and I need to match it to the value “Zip Code” in the datatable. I will have multiple match options like “Zip Code, Country, State” etc
The item coming in via the queue will be variable
When I come in with my queue item it might be “zip” or “st” or “co”, etc. I need marry it up to my list/array mentioned above.
If the string you’re getting is part of the column name, you could iterate over DT.Columns and find the name which Contains “zip”, “st”, etc., and set that column as the one you want to search.
There must be an identifier for determining which column to search, or else you’re going to have to search every field in the data table, iterating over your columns and rows.