Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jack350
-
I have a table with a field labeled
The pattern is, the string i want appears after the second space. There can be other characters after the 10-digit string I want, but those can be discarded. for example, field 1: Sacramento, CA 95210C11 United States I want to extract just the "95210C11" part- jack350
- Post #5
- Forum: Microsoft: Access Other topics
-
I have a table with a field labeled
The pattern is, the 10-digit string always appears AFTER the 2nd "space".- jack350
- Post #3
- Forum: Microsoft: Access Other topics
-
I have a table with a field labeled
I have a table with a field labeled "description". In this field are 10 digit numbers I want to extract and put in their own field in the same table so that I can link another table to it. for example field 1: Sacramento, CA 95210C11 I want to extract just the "95210C11"...- jack350
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
