Find first Alpha Character

[scotthutchings]

I have a variable length project number from which I need to extract just the numeric portion. How do I determine the location of the first alpha character?

Location = InStr(MyField,???)

 

[DJkarl]

Well if your project number is always just numeric up until an alpha character you could use the val function (i.e. 1234abcd) (val would return 1234 in this case). If you have alternating numeric/text values such as (1a2a3a4a) you would need a custom function to extract all the numbers, val will return 1 and stop at the first string it finds.

Location = Val(MyField)

 

[scotthutchings]

Perfect! This is just the function I was looking for!

Thanks for your help!