The majority of the extract number functions return the number value at and to the immediate right of the of the location in the string selected. The main exception being extracing number from the end of a striing. These functions work backwards (or left-wards) from the end of a string.

The user therefore needs to take care about the position in the string that he selects as the starting point. The diagram below shows the impact on the result of changing the position variable in the string Stephen83W8765Allen.

Note that at positions 12 and 13 you start to lose the left hand figures in the string 8765. This reflects the correct operation of the extraction algorithm, however the equivalent function Number Value at String Position under the Number Arrays in Strings approach, operates on the whole number.

Remarks

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also

Beginning of String - Integer | Beginning of String - Decimal | End of String - Integer | End of String - Decimal | From a Position within a String | After a character group within a string | Nth Digit in a string | Numbers inside Strings