-
Replace decimal zero’s with dash
I’ve got an expression that generates numbers to currency.
when the amount is a round number with “,00”, is it possible to replace the zero’s with a dash?I’ve got the following expression working:
v=thisComp.layer("Grocerylist#1.csv")("Data")("Outline")("KidsCost")("KidsCost 4")
new Intl.NumberFormat('nl-NL', {
style: 'currency',
currency: 'EUR',
useGrouping: true
}).format(v);
-
3 Replies
-
Dag Gerben,
try this tweak:
new Intl.NumberFormat('nl-NL', {
style: 'currency',
currency: 'EUR',
useGrouping: true
}).format(v).replace(/00$/gi,"—");Don’t worry about the $, in this case it doesn’t mean a dollar, but 00 “at the end of a string”, so € 100,00 doesn’t become 1–,–.
just using .replace(“,00”, “,–”) could work too actually.
-
He Filip,
Thnx again!
In the meanwhile I did find the ‘replace’ function but dit not know where to place it in the expression. Now when I see it it makes total sense 😄.As a sidenote: the top expression works, the bottom version not.
Response is:
Error: Syntaxerror: Invalid or unexpected token
The second quotation mark after the zero is blue. Adding a space doesn’t solve it.
Gr G
-
Yes, I didn’t put that in a code-block, so the wordpress layouter changed the quotes to curly brackets, this gives an error when copy-pasting…
This is what it could have been:
new Intl.NumberFormat('nl-NL', {
style: 'currency',
currency: 'EUR',
useGrouping: true
}).format(v).replace(",00",",—");
Reply to this Discussion! Login or Sign Up