[AccessD] instr() - Need an exact match

The trouble with just using strcomp that way is that it will give you a
false match if the search string contains the sought string like this

Searchstring = "ABCDE", SoughtString = "BC".

Your code will return 0 as the sought string is contained in the search
string, but John wants to find the exact string "BC" with only spaces,
commas or nothing either side of it.

Lambert

> -----Original Message-----
> From:	Brett Barabash [SMTP:BBarabash at tappeconstruction.com]
> Sent:	Thursday, September 11, 2003 5:25 PM
> To:	'Access Developers discussion and problem solving'
> Subject:	RE: [AccessD] instr() - Need an exact match
> 
> Oops,
> That should read:
> StrComp(Mid([StringToSearch],InStr([StringToSearch],
> [SearchFor]),Len([SearchFor])),[SearchFor])
> 
> But you get the idea...
> 
> 
> -----Original Message-----
> From: Brett Barabash [mailto:BBarabash at tappeconstruction.com]
> Sent: Thursday, September 11, 2003 3:57 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] instr() - Need an exact match
> 
> 
> How about:
> 
> StrComp(Mid(InStr([StringToSearch],
> [SearchFor]),Len([SearchFor])),[SearchFor])
> 
> 
> -----Original Message-----
> From: John Skolits [mailto:askolits at ot.com]
> Sent: Thursday, September 11, 2003 3:36 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] instr() - Need an exact match
> 
> 
> Here is a better example. In this case both function return a 1
> 
> 
> StrComp("SecGrp_Eng_Super, secGrp_Admin", "SecGrp_Eng_Super")
> 
> 
> StrComp("SecGrp_Eng_Super, secGrp_Admin", "SecGrp_Eng")
> 
> The first one is an exact match, the second a partial match. I want to
> distinguish between the two.
> 
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
> Lambert
> Sent: Thursday, September 11, 2003 4:13 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] instr() - Need an exact match
> 
> 
> I'm not clear on why InStr() does not suit your purpose.
> 
> InStr("a_Group,b_Group,c_Group","c_Group") will return a non-zero value
> (17), meaning that "c_Group" was found in the first string. Now if you
> want
> an exact match that takes the case into account you can use...
> 
> InStr(1,"a_Group,b_Group,c_Group","c_group",vbBinaryCompare)  ' note, must
> supply the start position - 1
> 
> which will return zero as "c_group" is not found, whereas
> 
> InStr(1,"a_Group,b_Group,c_Group","c_Group",vbBinaryCompare)
> 
> returns 17.
> 
> Lambert
> 
> > -----Original Message-----
> > From:	John Skolits [SMTP:askolits at ot.com]
> > Sent:	Thursday, September 11, 2003 3:54 PM
> > To:	Access Developers discussion and problem solving
> > Subject:	[AccessD] instr() - Need an exact match
> >
> > Is there a way to do an exact match with something like Instr(). I don't
> > want a partial match.
> >
> > For example:
> > I have a string:    "SecGrp_Admin, SecGrp_Eng, SecGro_User"
> >
> > I want to look see if "SecGrpAdmin_Super" is in the string. Instr() will
> > return a value but I want an exact match.
> >
> > I know I can parse the string and look for an exact match based on the
> > parsed value. I just thought maybe there's a function I can use that
> would
> > do an Exact match test.
> >
> > John Skolits
> >
> >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --------------------------------------------------------------------------
> --
> ----------------------------------------
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom
> they are addressed.
> If you have received this email in error please notify the
> originator of the message. This footer also confirms that this
> email message has been scanned for the presence of computer viruses.
> 
> Any views expressed in this message are those of the individual
> sender, except where the sender specifies and with authority,
> states them to be the views of Tappe Construction Co.
> 
> Scanning of this message and addition of this footer is performed
> by SurfControl E-mail Filter software in conjunction with 
> virus detection software.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --------------------------------------------------------------------------
> ------------------------------------------
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom
> they are addressed.
> If you have received this email in error please notify the
> originator of the message. This footer also confirms that this
> email message has been scanned for the presence of computer viruses.
> 
> Any views expressed in this message are those of the individual
> sender, except where the sender specifies and with authority,
> states them to be the views of Tappe Construction Co.
> 
> Scanning of this message and addition of this footer is performed
> by SurfControl E-mail Filter software in conjunction with 
> virus detection software.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com