After string Pattern

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

The parameters required are

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


  Last Updated: 02/04/2009 | © ACBA (UK) LTD, 2009