just do two searches.
1. ',00' -> nothing
2. (EUR) +([0-9\.]+) -> $2\sEuro
which will work for those examples
.. or in a single search-and-replace
This will automatically delete the ",00" part where necessary.
Wonderful, thanks a million Hans-Gerd!
your single search and replace is "excellent"
thanks for helped me too... as i have the same issues.....
be very very carefull.
if you have something like
it will be replaced with 15 Euro,15 using bouth solutions.
use -hans-'s solution, with 2 searches, and change the second one to: (EUR) +([\d\.,]+) -> $2\sEuro
Vamitul, it's not unusual that there are things that can go wrong. But both our suggstions work correctly on the specified list -- and Ralf did not say what should happen when there is a number in cents, so it seems he wants to throw them away.
If not: here is a single GREP that will move the EUR to the back and discard only ",00" cent values; other cents are preserved.
replacing again with
EUR 250.000 -> 250.000 Eur
EUR 250.000,00 -> 250.000 Eur
EUR 2.000,01 -> 2.000,01 Eur
EUR 15,05 -> 15,05 Eur