Here is a change to my formula.
whilereadingrecords;
if length(Your data field) (not equal symbols) 0 then
if numerictext(mid(Your data field,3,length(Your data field)-2)) then
tonumber(mid(Your data field,3,length(Your data field)-2))
Else
0
Else
0
Once you have the formula you should be able to insert a summary field on the formula
Are the two alpha and remaining numeric characters always in the same position within the string?
Are the two alpha characters always going to be the same?
Is the length of the numeric value following the two alpha characters always going to be the same?
The more no answers you have to the above the tougher it will be!
Get back with the above answers and possibly copy and paste some examples of the ENTIRE strings from which you will be extracting the values and let us know which are the values you'll be pulling from within the larger string.
"I need to extract the number, if it exists, from an alphanumeric text string. I am told that the first two characters will be alpha and the remaining character(s) will be numeric, if the numeric exists at all.
I know this is a simple formula, but I can't quite get it."
Add a comment