Job description
Hello, I need a script that will work on 2 files simultaneously:
1. project in Adobe InDesign
2. Word / Excel in which there will be a table (x rows, 2 columns)
The script should
1. scan all text content from Adobe InDesign project
2. the program looks for the same text in Word/Excel in the first column starting from the longest phrases, copies the content of the same line, but from the second column and pastes it into the Adobe text frame (text replacement)
3. after finishing the work, the program generates a report whether it has managed to replace everything in InDesign, and if not it shows the excel file with marked in red columns that could not be found
4. The program should have a function that can be selected, so that when comparing texts, you can consider that if the texts are the same, but for example in one of the texts is an enter / a few spaces more then it ignores it and despite this text is replaced, that is to ignore the white characters.
