Hi Everyone,
I am trying to get just the numbers from a line of text, and here is the original text: ALBANY, NY (31534). The number of digits does not change, but there are many different states in the field (ex: Minneapolis, MN (21433) so the character size will vary.
here is what i have tried so far:
Expr1: Right([textbox7],InStr(1,[textbox7],"("))
Any help would be much appreciated, thank you!
I am trying to get just the numbers from a line of text, and here is the original text: ALBANY, NY (31534). The number of digits does not change, but there are many different states in the field (ex: Minneapolis, MN (21433) so the character size will vary.
here is what i have tried so far:
Expr1: Right([textbox7],InStr(1,[textbox7],"("))
Any help would be much appreciated, thank you!