I have file where 1 of 1000 lines, the schema is like “12345,ADM”.
Now let’s say I want to search if “54321,DMA” is in that list. If so return true.
Now I could use the Read TXT activity and afterwards a For Each activity. But that not performant I would say.
The other idea was to use the Read CSV activity and setting the delimiter to something other then a comma. But I don’t think that it’s way faster.
What would be a better way. Maybe writing some lines with Invoke Code activity?