Sidebar
en:transformation:mappings:funktionen:numerisch:makenumeric
Table of Contents
MakeNumeric
The function MakeNumeric() accepts a numeric value with followed minus sign and returns it as a negative numeric value.
see also MakeNumericEx
Syntax:
MakeNumeric('Value')
MakeNumeric('Value', <Empty Value>)
Sample
| Code | Result |
|---|---|
MakeNumeric('')
| NULL |
MakeNumeric('', 0)
| 0 |
MakeNumeric(' ', 0)
| 0 |
MakeNumeric('aaa')
| NULL |
MakeNumeric('aaa', -1)
| NULL |
MakeNumeric(<Empty x-path result>) | NULL |
MakeNumeric(<Empty x-path result>, 0) | 0 |
MakeNumeric('6.25-' )
| -6.25 |
MakeNumeric('6,763.5')
| 6763.5 |
MakeNumeric('6.971,12')
| 6971.12 |
en/transformation/mappings/funktionen/numerisch/makenumeric.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1