-
1. Re: Rounding up decimal prices - GREP ?
peter at knowhowpro Sep 12, 2011 1:28 AM (in response to Jaime de Vos)Jaime de Vos wrote:
As you can see, I'm not quite sure how to phrase this question, so I translated it rather literally from Dutch. But I digress...
I'm currently working on a price list for our sales organisation, and they've given me prices that are formatted as shown below.
What I need to do is find two decimal numbers, remove them and round up the price, or when the decimal numbers are ",00", then I merely need to remove the ",00".
Is there a GREP or Script that can help me out with this, because I really shudder at the thought of having the redo all those prices.
Example:
€ 10.762,50
€ 11.812,50
Need to look like this;
€ 10.763
€ 11.813
Alternatively, numbers that are formatted like this,
€ 10.300,00
Need to look lis this;
€ 10.300
I hope I explained my problem in a clear manner. If I haven't, please don't hesitate to let me know!
Thanks in advance, everyone.
I don't know if GREP can do this.
Search Google for terms like "indesign round numbers script" without quotes for some leads.
Also, dtptools.com's Active Tables plug-in for InDesign works like a spreadsheet, so you can define formats and formulas for cells. There's a ROUND function. I'm not sure there's a numeric display format that supresses the decimal point and trailing zeros. You can experiment with the trial, or ask their tech support - it's very prompt, allowing for time differences across the globe.
HTH
Regards,
Peter
_______________________
Peter Gold
KnowHow ProServices
-
2. Re: Rounding up decimal prices - GREP ?
Eugene Tyson Sep 12, 2011 1:39 AM (in response to Jaime de Vos)No you can't do this with GREP.
-
3. Re: Rounding up decimal prices - GREP ?
Jaime de Vos Sep 12, 2011 1:47 AM (in response to Jaime de Vos)Thanks for that, I'll look into the script functions.


