Mike Summer Posted March 30, 2006 Share Posted March 30, 2006 I want to know how extract part of a field. For each record, I want to extract the last part of an email address. For example if the email address is [email protected], how can I extract 'world.com'. Your reply is much appreciated. Link to comment Share on other sites More sharing options...
aaa Posted March 30, 2006 Share Posted March 30, 2006 Hi, Mike! This is one of ways: Middle ( Email;Position ( Email;"@";1;1)+1;1000 ) You can use Right() function too. Link to comment Share on other sites More sharing options...
Mike Summer Posted March 30, 2006 Author Share Posted March 30, 2006 It works perfect. Much appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6602 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 accountSign in
Already have an account? Sign in here.
Sign In Now