The 'NthINT' function returns the Nth digit it finds within a string. When counting N, only those characters that are numeric are included in the count.

The parameters required are

• the column address of the datalist you want to analyse (choose a letter from the dropdown text box)
  
• Nth - The 1st, 2nd, 3th etc digit that you want to report
  

The results from the form look like this.

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