I iamraja5 Registered User. Local time Today, 02:34 Joined Jun 2, 2006 Messages 11 Jun 2, 2006 #1 Hi all I have field Name called EMPNAME The records like this, Brian,Smith Ray,Vernner Ken,Ibrahim Now I want to separete them as Firstname: Brain How do I find the comma "," in a text? thanks
Hi all I have field Name called EMPNAME The records like this, Brian,Smith Ray,Vernner Ken,Ibrahim Now I want to separete them as Firstname: Brain How do I find the comma "," in a text? thanks
KeithG AWF VIP Local time Today, 02:34 Joined Mar 23, 2006 Messages 2,591 Jun 2, 2006 #2 You will have to write a VBA function to do this. I have seen threads in the past talk about similar problems. Try searching for Pharsing text.
You will have to write a VBA function to do this. I have seen threads in the past talk about similar problems. Try searching for Pharsing text.
I iamraja5 Registered User. Local time Today, 02:34 Joined Jun 2, 2006 Messages 11 Jun 2, 2006 #3 I serached and could not find any in the past threads... Can't I do this in a single query?
Smart Registered User. Local time Today, 10:34 Joined Jun 6, 2005 Messages 436 Jun 2, 2006 #4 Try rthis in your query SELECT InStr([Yourfield],",")-1 AS pos, Trim(Left([Yourfield],[pos])) AS firstname, Len([Yourfield]) AS namlen, Trim(Right([Yourfield],[namlen]-[pos]-1)) AS surname FROM yourtable;
Try rthis in your query SELECT InStr([Yourfield],",")-1 AS pos, Trim(Left([Yourfield],[pos])) AS firstname, Len([Yourfield]) AS namlen, Trim(Right([Yourfield],[namlen]-[pos]-1)) AS surname FROM yourtable;
I iamraja5 Registered User. Local time Today, 02:34 Joined Jun 2, 2006 Messages 11 Jun 2, 2006 #5 awsome, it workd....thank alot. "For me you are the world"
Smart Registered User. Local time Today, 10:34 Joined Jun 6, 2005 Messages 436 Jun 2, 2006 #6 RE:RE:How to identify a charector Glad to be of help
