Here’s a thought on the wildcard table lookup…
If you can load the table on the fly and convert it into 2 lists, 1 for input and 2nd for output. You could then search either side of the list using a wildcard and then reference the matching element in the other list.
I’ve done the first part, but haven’t had any need for a wildcard lookup in a table.
Steve Carter