eBiss 3 en:transformation:mappings:funktionen:numerisch

Abs

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Abs The Abs() function returns the absolute value to a numeric value. Syntax: Abs() Examples: CodeResultAbs('97.232') 97.232Abs('-97.232') 97.232Abs(363) 363Abs(-363) 363

CheckNumeric

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

CheckNumeric The function CheckNumeric() gets a string to be checked for literals as a parameter. The function returns this string if it does not contain any letters. If letters are included, an error message is displayed. Note: If you do not want to receive an error message but a NULL, please use

CheckSumM10

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

CheckSumM10 The function CheckSumM10() gets an EAN as parameter and returns the checksum of this EAN as String. Syntax: CheckSumM10('EAN') Sample: CheckSumM10('123456789123')

CustomNumberFormat

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

CustomNumberFormat Use FormatNumber. Syntax: CustomNumberFormat('Wert', 'Format','Dezimaltrennzeichen', 'TausenderTrennzeichen')

CustomNumberFormatEx

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

CustomNumberFormatEx Use FormatNumberEx Syntax: CustomNumberFormat('Wert', 'Format', '[N/Y] Kultur-abhängige/-unabhängige Formatierung', 'Dezimaltrennzeichen', 'TausenderTrennzeichen')

Division

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Division Use the XPath function div to divide two numeric values. Syntax : a div b Sample: '6' div '3,5' = 1,7142857142.

FormatNumber

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

FormatNumber The FormatNumber() function can be used to convert numeric values into country-specific formats. The following link describes the formatting: https://msdn.microsoft.com/de-de/library/0c899ak8(v=vs.110).aspx Note: FormatNumber() only makes sense if the target element is of type string! When containerizing according to EDIFACT, NullableNumeric data elements are defined with a '.' as a decimal separator.

FormatNumberEx

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

FormatNumberEx You should use normally FormatNumber. Use this only if you want to read numeric values in your machine format. Syntax: FormatNumberEx('Wert', 'Format', '[N/Y] Kultur-abhängige/-unabhängige Formatierung', 'Dezimaltrennzeichen', 'TausenderTrennzeichen')

MakeNumeric

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

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', ) Sample Code Result MakeNumeric('')

MakeNumericEx

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

MakeNumericEx See also MakeNumeric Syntax MakeNumericEx('Value') MakeNumericEx('Value', ) Sample Code Result MakeNumericEx(' ') NULL MakeNumericEx(' ', 0) 0 MakeNumericEx('aaa') NULL MakeNumericEx('aaa', -1) NULL MakeNumericEx()

Max

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Max The function Max() takes an X-path expression as value and returns the largest result of the expression as value. The Min function serves as a counterpart to this. Advice The transferred values are interpreted and compared as numerical values. If this is not possible, the values are compared as a < z (a < A < z < Z).

Min

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Min The Min() function takes an X-path expression as a value and returns the smallest result of the expression as a value. The Max function serves as a counterpart to this. Advice The transferred values are interpreted and compared as numerical values. If this is not possible, the values are compared as a < z (a < A < z < Z).

NotEmptyNumeric

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

NotEmptyNumeric The function NotEmptyNumeric () checks whether a variable contains a numeric value, no or an invalid value. If the value of the variable is invalid, an empty string is returned as the result. This prevents further processing within a Ruleset. The RuleSet is simply skipped without an error being triggered. | It is also possible to specify a second argument within the function to specify the zero value with which the value in the first argument is to be compared. If both values a…

Number

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Number The function Number() takes a String and returns a number. It is possible to convert a string into a certain data type by specifying the data type as a second parameter in order to perform arithmetic operations using XPath. Typ Description

Round

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Round The Round() function accepts a value, the number of decimal places and the information about whether rounding up or down is performed and returns the rounded result. Syntax: Round(@Value, 'Number of decimal places', 'rounding type') Number of decimal places

Numerical functions

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Numerical functions All functions that generate or process numeric values. Themen numerisch index