This form returns the first whole number found immediately to the right of a specified character string.

The parameters required are

• the column address of the datalist you want to analyse (choose a letter from the dropdown text box)
  
• The string characters after which the number should be extracted
  
• The position within the search string from which to start looking for the string characters
  

The form to process number extraction from a list looks like

The results take the form of a list with an audit trail heading

Remarks

This function returns a string value of '#Error', if it cannot resolve the parameters provided.

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

See also

Numbers inside Strings - Form Based | Extract Number