Quark Forums

Hi Jon, I think I've got it. While yesterday it seemed impossible, I have found the way around the many obstacles. :-) The script had to be rewritten completely, because the replaced SKU numbers have to be marked with a color. The job has been quite difficult: The Excel file has two columns with 9500+ numbers each. The numbers ...

Hi Jon, you're welcome, but: easy now! ;-) Well ... the first version is ready and working with ... my simple test files. There is no use to send you the droplet, without having tested it with your sample files. As I have explained, today, in a private email exchange. Meanwhile I have received them and ... the task is not ...

Hi Jon, good news: I'm ready! :-) I have translated the S&R droplet and made a special SKU version of it which handles Excel files as well. When an Excel document is dropped on the icon of the droplet, the file is opened, the script extracts column A and column B, then it loops through the stories of the XPress project and ...

Hi Jon (hi Emma :-), Matthias has sent me a link to your request. The S&R script, which he has recommended, could do the job. But it expects a text file, where each paragraph contains an old number, a separator and a new number. Some years ago, I have done a couple of scripts which replaced the SKU numbers in an XPress document. I'll ...