Hello guys… I come back here on the forum with a new issue.
I have to create an automation which sorts some images based on a few conditions.
All images come from an electoral campaign - each one contains some details about the candidate - either the candidate’s surname, last name or political party which they are affiliated to.
My robot has to create folders for each of these candidates and place the images inside of the proper folders. I have also been provided with a list in form of an Excel spreadsheet, which contains all candidates’ names and political parties.
Naturally, I’ve used an OCR engine for text extraction from the images, and sorted through them via the contains method - My workflow contains 3 Ifs - one that looks for the political party, one that looks for the surname and one that looks for the last name.
My problem is this : One of the images contains both the surname and the name of one candidate, BUT ALSO the name of a political party WHICH HE IS NOT AFFILIATED WITH (this is the catch).
As my robot tries looking for the political party first, it obviously reads that other party’s name and moves the picture in the wrong folder…
So, TL:DR, If 2 conditions are technically met, although one is NOT correct, how can I make the robot pick the proper one? (in this case, sort based on either NAME or LAST NAME)
This is the picture that gives me trouble. In the top left you can see the name and surname, and on the bottom , “PSD” is the name of the political party that messes up my sort!!
Sorry for the long text, I had to give you some context. Thanks a bunch for everything!