Rabu, 06 April 2016

Re: Re: [MS_AccessPros] Split a text field into two text fields.

 

John-
It works great! Thanks a lot.
Best Regards,
Kevin


 
Date: 2016-04-06 18:24
Subject: Re: [MS_AccessPros] Split a text field into two text fields.
 

Kevin-


FirstName: Left([PassengerFullName], Instr([PassengerFullName], " ")-1)

FamilyName: Mid([PassengerFullName], Instr([PassengerFullName], " ")+1)

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 6, 2016, at 12:21 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Duane-
I think I know to how to solve my problem. I am going to try to use Right() to find the first space, then to use Instr() to get the family name. And the same way to get first name. Thanks a lot.
Best Regards,
Kevin

 
Date: 2016-04-06 12:11
Subject: RE: [MS_AccessPros] Split a text field into two text fields.

Kevin,
Do you really want to include the titles with the names?
Are there always a first name, space, and last name?
 
Have you looked into the string functions like Instr(), Left(), Right() , and Mid()?
 
What have you tried so far?
 
Duane Hookom, MVP
MS Access
 

To: ms_access_professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 6 Apr 2016 12:00:49 +0800
Subject: [MS_AccessPros] Split a text field into two text fields.




Dear All,

I have a text field called "PassangerFullName", for example:

PassangerFullName: Jack Smith

My question is: how to split this "PassangerFullName" into two text field,namely "FirstName: Jack" and "FamilyName: Smith"? Thanks in advance.

Best Regards,
Kevin







__._,_.___

Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!


.

__,_._,___

Tidak ada komentar:

Poskan Komentar