Duane
I am having a real issue here. I have tried the instr and the below expressions have not worked. I must have the syntax wrong
Full Name: Trim(Left([Household],InStr([Household],"&")-1))
Full Name: ([Household],InStr(Trim(Left[Household],"&")-1))
Full Name: Trim([Household],InStr((Left[Household],"&")-1))
Full Name: ([Household],InStr(Trim(Left[Household],"&")-1))
Full Name: Trim([Household],InStr((Left[Household],"&")-1))
Jim Wagner
From: Duane Hookom <duanehookom@hotmail.com>
To: access developers <accessdevelopers@yahoogroups.com>
Sent: Thursday, December 1, 2011 4:37 PM
Subject: RE: [AccessDevelopers] Left string question
Jim,
The Instr() function will return the position of one string within another. You can combine this with the Left() function to return only the characters to the left of the "&".
Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Thu, 1 Dec 2011 14:14:29 -0800
Subject: Re: [AccessDevelopers] Left string question
From: Duane Hookom <duanehookom@hotmail.com>
To: access developers <accessdevelopers@yahoogroups.com>
Sent: Thursday, December 1, 2011 3:05 PM
Subject: RE: [AccessDevelopers] Left string question
The Instr() function will return the position of one string within another. You can combine this with the Left() function to return only the characters to the left of the "&".
Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Thu, 1 Dec 2011 14:14:29 -0800
Subject: Re: [AccessDevelopers] Left string question
Duane,
That works except I want to get rid of the entire second name if it exists. I only want to see the first persons name not the spouse.
Jim Wagner
From: Duane Hookom <duanehookom@hotmail.com>
To: access developers <accessdevelopers@yahoogroups.com>
Sent: Thursday, December 1, 2011 3:05 PM
Subject: RE: [AccessDevelopers] Left string question
You can use the Replace() function to replace the "&" with "". You might want to replace " &" with " ,".
Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Thu, 1 Dec 2011 21:34:06 +0000
Subject: [AccessDevelopers] Left string question
Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Thu, 1 Dec 2011 21:34:06 +0000
Subject: [AccessDevelopers] Left string question
Hello all
I have a field that has a name field with the examples Below.
I would like to get rid of the & in the string. But I cannot find any Left to get rid of a character like an &.
Is there no way to get rid of that character?
Thank
Jim Wagner
Smith, John David & Mary Lynn
Jones, Frank & Cammie Deborah
Lee, Jim
I have a field that has a name field with the examples Below.
I would like to get rid of the & in the string. But I cannot find any Left to get rid of a character like an &.
Is there no way to get rid of that character?
Thank
Jim Wagner
Smith, John David & Mary Lynn
Jones, Frank & Cammie Deborah
Lee, Jim
__._,_.___
Please zip all files prior to uploading to Files section.
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar