validating that a character is entered in a text item or not

[taqmeena]

i want to know that who many character & numbers are entered in a charater type field
example:
value is = 'i4554you'
here lenght = 8
and characters are 4 and numbers are 4
can we access these figures at runtime for a field.

-- note i know we can check whether a number is entered or not in a text filed by using the TRANSLATE fuction.
but this did not give actual Sum of Numbers

 

[lewisp]

Look at TRANSLATE or create a function to work out which of the characters are numbers one by one.