InDesign Scripts for Changing Currency

You're right, Robert. I was confused by Daniel's use of 'rounding up, because what he really wants is, well, I don't think there's a standard term for it. 'Rounding up to the next integer minus 0.01' maybe. Anyway, this will andle it:

(function () {
  app.findGrepPreferences = null;
  app.findGrepPreferences.findWhat = '(?<=[£€$])?[\\d,]+\\.\\K\\d+';
  app.findGrepPreferences.appliedCharacterStyle = 
    app.documents[0].characterStyles.item('RRP');
  
  var s;
  var found = app.documents[0].findGrep();
  for (var i = found.length-1; i >= 0; i--) {
    if (parseInt(found[i].contents) > 0) {
      found[i].contents = '99';
    }
  }
}());

You can't do that with a GREP in the interface (it can't do calculations). You need a separate script for that (it's to be added to the script):

(function () {
  app.findGrepPreferences = null;
  app.findGrepPreferences.findWhat = '(?<=[£€$])?[\\d,.]+';
  app.findGrepPreferences.appliedCharacterStyle = 
    app.documents[0].characterStyles.item('RRP');
    
  var found = app.documents[0].findGrep();
  for (var i = found.length-1; i >= 0; i--) {
    s = Math.ceil(found[i].contents.replace(/,/g,''));
    s = String(s).replace(/(\d)(?=(\d\d\d)+\b)/g,'$1,');
    found[i].contents = s + '.00';
  }
}());

> When I go to run the price adjuster script, using htr attached settings, no conversion happens.

To troubleshoot, set a colour in the character styles so that you can see exactly where they are applied. Each style a different colour, of course.

Check that the styles were applied correctly, then try the script again.

> Is that a requirement for your script - that ONLY digits should be styled?

Correct. Well, digits, dots, and commas.

Meanwhile Robert suggested more or less the same while I was posting, which is confusing.

Note that Robert's GREP expression to apply style to numbers targets all numbers, nit just RRP and Trade prices. And the GREP doesn't allow for large numbers that contain thousand separators (commas).

> this is the format for the entire catalogue...

Ok, finally. Do this:

1. Create two character styles, one called Trade, the other, RRP. They need no formatting.

2. Apply the RRP style to RRP: £\K[\d,\.]+

3. Apply the Trade style to TRADE: £\K[\d,\.]+

You can apply these styles using the GREP tab of the Find/Change window.

Then you can use the price adjuster script.

> Both RRP and TRADE have the same character styles

Ok. But the question remains: how can you tell these prices apart. Not by character style, as you say. But I need to know what distinguishes them. Paragraph style? Cell style? Anything at all?

If the prices cannot be distinguished in any way  you needn't even start worrying about GREP.

The first question, indeed, is how you tell apart the RRP and Trade prices.

@DanielAustinCarat 

Do you have different CharStyles applied to RRP and TRADE prices?

Because last option - TARGET CHARACTER STYLE - will change only values styled by selected CharStyle.

OK, you need to round values.

If you are in a hurry - you could play with GREP - do conversion without decimal places, then add".00zł" - for RRP of course.