Indeed as Loic mentioned, I believe his script solution posted here  is more elegant and slightly more suitable for my case, for those reasons: - Adding a library item similar to the previous ones with new color code (in case the client adds some next year) is slightly easier and makes the whole thing more "portable" - It avoids the hassle of creating over a 100 GERP styles for each scenario, each of them specific to the name string for each color name. - They also have 2 versions of the catalog that I can apply the same "recipe" to. - Having the whole string as my cell data ("n 100 | Noir" for example, n being the webding/Zingbaf character) could cause problems for csv files: special characters are often not very well handled (to be confirmed). This technique however poses 2 main issues: - Editing library items is a painful process, and the simple task of reducing font size (as I will probably have to do) is tedious. - I currently have a spacing / tab issue, as for some items I have to display 3 color codes side by side over 3 lines which is complicated to perform as Library items retain their frame size when added via script as anchored objects. Currently trying to tackle that with GERP actually (on smaller scale), or simply by changing layout or data itself (maybe single spaces only after the color code in excel?). ... View more

I don't know what to say. YOU ARE AWESOME ! thank you so much for this. ... View more

I believe the issue is that it can't perform the placement if there is any other string of text inside a text frame apart from the color code it looks for. I tested with various items (including for example a tab or a single space before or after the "XXXcolor" string) and whenever there is some other text (or a 2nd color code), the action does not perform: EDIT: Any string of text EXCEPT a return. When placed on 2 different lines on a single frame, the script executes properly for both. Investigating further myself! Thanks for your help Loic, if you identify where the problem could be, feel free to let me know 😉 ... View more

Thank you SO much Loic. That worked perfectly for a single item, except if I have more than one color code in a paragraph the script alerts "All went fine" but it doesn't replace any of them. As a test I tried: - Making large paragraphs / text frames - Running the script first with just a single "100color", then after it performed properly, adding a second piece of text "360color" for example, but nothing happens after that first change. Damn I feel I am so close (well, YOU are 😉 I'm trying to look at the code but can't find the bit that wouldn't allow it to run each time until it went through the whole color list. If that helps, the max number of color number is 999, we don't have colors past that (maybe a for loop instead of while ?). Note that there are colors that are not yet matched by an item (for example, there isn't any "101color" neither in my library nor my document). Maybe it stops for that reason ? Thanks so much again for your help nonetheless. ... View more

I'm trying something simpler now, as I went on another path. I've created a library item for each of the color text strings (I recreated each of them in InDesign from Illustrator, since copy/paste doesn't work from one software to the other...). Now I would only have to build a script that search for, let's say, "102color" text in the indesign document, and replace each instance by the item called "102color" in my InDesign library. It feels like it's the right way to go about this (at least more achievable, right?). Any chance you know how I can build such script? ... View more