seanc Posted March 1, 2005 Share Posted March 1, 2005 Hi All, I have a text field which contains basically random characters, alpha, numeric and symbol. I need a calculation which returns characters only up to the first non-alpha character. So: "xyz2y" returns "xyz" "y2r" returns "y" "abc$tyu" returns "abc" etc! Another of those problems I expected to be easy, but have only come up with kludgy, long-winded solutions for. Thanks...Sean! Link to comment Share on other sites More sharing options...
This topic is 6601 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now