OK - so here’s the challenge …
I have an Excel file that is a master translation document.
It contains English text in column B, French text in column C, Spanish text in ‘D’, etc, etc.
The rows contain an ingredient, so for example - B2 is “soap”, C2 is “savon”, D2 is “jabón”
Hope your with me so far.
I then get a 2nd Excel file that contains the ingredients for a job as a line of text, one after the other (in English), and it also contains details of what the language should be.
Example of line of text: “15-30% Anionic surfactants, Non-ionic surfactants, Soap”
So when it’s French it should be “15-30% Tensio-actifs anioniques, Tensio-actifs non-ioniques, Savon”
How can I get Applescript it to change to the language they are supposed to be in (by looking at the master document) ???
Its like I need it to read the text line, identify when it sees an ingredient that matches an ingredient from column B (English) - change it to the same row value, but column C (French).
Hope I’ve described the problem ok.
I have no idea where to start. Grateful for any help.