Hi everybody
I'm sure this is a really basic question but I am just learning regular expressions. I want to be able to take any combination of 1.255 EUR or 345.567,00 € or 7 EUR and move the EUR to before the digit and then have the US number format. So the result would be EUR 1,255 or EUR 345,567.00 or EUR 7. I've tried substituting $1 and $2 etc. but not much luck yet. Sorry if this is really basic.
Thanks!
Greg
Of course I meant change € to EUR in the title
Hi Gregory Rayner ,
That's not basic at all so you might be better off using three expressions for this. So like this:
1.255 EUR could be
(\d+)\.(\d+)\sEUR
EUR $1,$2
345.567,00 € could be
(\d+)\.(\d+),(\d+)\s€
EUR $1,$2.$3
7 EUR could be
[^.,0-9]\d+\sEUR
EUR $1
Would be an interesting Xmas puzzle to do all of that, and the replace, in one expression. I'm not even sure it's possible.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Translate
