You cannot use arithmetic or mathematical functions on strings even though they may contain numbers that you want to manipulate. ACBA Tools offers two distinctive and very different methodologies to the extraction of numbers within strings.

• The first approach extracts a single number depending on its location within the string. Mostly it will only identify integers, but, for numbers at the beginning or end of strings, the method can also return decimal values.
  
• The second approach locates all the distinctive number groupings in a given string. These groupings can be either integers or decimal values irrespective of their string location. The number value, location and string length of the digits that give rise to the value are reported by reference to the position of the number group in a temporary array (or database).
  

Remarks

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

See also

Sharing Results | About ACBA Tools