I asked a similar question a few years ago (Seeking elegant way to make a selection based on contents of an array) and got helpful responses. I can’t see how to use arraycontains
in this case though. To be clear, for each record in the database, the OriginalOrder field contains a multi-line array, where each line contains multiple elements separated by tabs, spaces, or hyphens.
So for one record in the database, which corresponds to a single order, the OriginalOrder field might contain this multi-line array:
1) 7490–B 1 15.00 $15.00 2 Red Onion
2) 7625–A 1 9.00 $9.00 2 Apple