fn:format-number() for german style numbers
Saturday, 27 October 2018 · 2 messages
WS
Wiemer, Sebastian27 Oct 2018 08:39 #
Hello everyone!
How do I format german style numbers e.g.: 1.000.00,99€ (for one million € and 99cents) ?
The following approach:
format-number(26825.8, '#.###,00')
yielded an error: [FODF1310] Invalid picture string: '#.###,00'.
Anyone an idea what is going wrong here?
Best regards,
Sebastian
Quoted text · 2 lines
------------------------------------------------------- >>> business. people. technology. <<<
-------------------------------------------------------
adesso AG mit Sitz in Dortmund
Vorstand: Michael Kenfenheuer (Vors.), Christoph Junge, Dirk Pothen, Andreas Prenneis Vorsitzender des Aufsichtsrates: Prof. Dr. Volker Gruhn
Amtsgericht Dortmund HRB 20663
MH
Martin Honnen27 Oct 2018 09:26 #
Quoted text · Wiemer, Sebastian · 12 lines
Am 27.10.2018 um 08:39 schrieb Wiemer, Sebastian: > > > How do I format german style numbers e.g.: 1.000.00,99€ (for one > million € and 99cents) ? > The following approach: > > format-number(26825.8, '#.###,00') > > yielded an error: [FODF1310] Invalid picture string: '#.###,00'. > >
declare decimal-format local:de
decimal-separator = "," grouping-separator = ".";
format-number(26825.8, '#.###,00', 'local:de')Written for BaseX 9.0. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery