I am trying to retrieve jobs from our freight system based on location.
We have a table containing location codes I am using to build my filter field.
Some of our 3 character codes have been updated to 5 character codes
Some jobs are missing, as they were input before the change, so still contain a 3 character code, not the new 5 character equivalent.
I need to build a filter field that contains all of the current codes I am retrieving from the table, unionized with a list of Excel cells, that have manipulated location codes in.
The Excel cells will retrieve a subset of 5 character codes, and remove the first two characters, to produce a list of old 3 character codes. I managed to get the two lists in Excel, but I obviously not in an array format that I could use with other NL functions.