I have a 40-page PDF price list from a supplier which contains hundreds of prices of various products. We'd like to run a formula over every single listed price and replace our supplier's "buy" price with our "sell" price so we can forward the document to our customers. The price list includes formatting, images and colours etc which we want to retain so exporting to Excel, Word etc isn't an option.
I'd like know if it's possible to create a script that can replace every single "buying" price in the document (all are prefixed with $) with our "selling" price.
Our simple calcuation involves multiplying the price by X and rounding to a ceiling of $10.
Thanks in advance for your help.
Thanks George - appreciate the response.
Some years ago, I had a similar task (with a few additional quirks, such as different pricing factors and different currencies).
This was pretty straightforward.
Thanks Maxwyss, that sounds basically identical to what we need to do!
Any idea about how I might go about doing that? I'm a bit of newbie to this unfortunately!
I've also developed a script that does essentially that. The issue with doing it is that the script can't know the font style, font color or background color (the font size can be figured out, more of less) of the text being used in the document. You can hard-code it, of course, but if it's not always the same in the entire document you will have to go back and manually adjust it later on, so it doesn't look out of place.
Explaining it in detail would be beyond the scope of this forum, but could be done in a direct conversation. If interested in either learning how to do it, or have it delivered to you, feel free to contact me in private.