My bot is reading 1 pdf file at a time and performing multiple operations.
After performing all the operations with the text read from pdf I want to rename the pdf files and store them in certain location, so for renaming there is condition that for eg:if the pdf text contains “X” rename it as"Type1" if “B” then rename as “Type2”.
I have stored all the keywords (which can come in the entire set of pdf files which I am processing) in 1st column of excel and also the the name which it has to be renamed to in the simultaneous cell in next column.
Now, I want the bot to go and check the first column from top and check if the if the first keyword exists in the pdf text then rename it with the simultaneous value in next column, if not found then move to next row of keywords.
Any suggestions will be very helpful.