Whole word Match

[Visio Candar Control]

I am using findfirst to locate records within my recordset. I would like the
record to be found only if the whole word exactly matches any word within the
sentence being searched. i.e.

String “Johnson Foodstore†returns false when searching for “John†but
String “John Smith Foodstore†returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe

 

[Alex Dybenko]

Hi,
you can try to search for %John %
with space at the end

 

[Visio Candar Control]

Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched =
“Johns Foodstore†the search string = “Johnsâ€

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or [ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe

 

[Alex Dybenko]

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched =
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message news[email protected]...

 

[Visio Candar Control]

Hi Alex
There appears to be a quote missing in your search string VBA complains off
an “expected end of statement when the line is pasted and highlights the
second [ProjectName]


Regards
Joe

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched =
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message I am using findfirst to locate records within my recordset. I would like
the
record to be found only if the whole word exactly matches any word
within
the
sentence being searched. i.e.

String "Johnson Foodstore" returns false when searching for "John" but
String "John Smith Foodstore" returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe

 

[Alex Dybenko]

yes, you right!

Hi Alex
There appears to be a quote missing in your search string VBA complains
off
an "expected end of statement when the line is pasted and highlights the
second [ProjectName]


Regards
Joe

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message news:[email protected]...

Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched =
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe




:

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message I am using findfirst to locate records within my recordset. I would
like
the
record to be found only if the whole word exactly matches any word
within
the
sentence being searched. i.e.

String "Johnson Foodstore" returns false when searching for "John"
but
String "John Smith Foodstore" returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe

 

[Visio Candar Control]

Hi Alex

I maybe right but I cannot workout where the quote should go. Could you
re-post the correct search string.

Regards
Joe

yes, you right!

Hi Alex
There appears to be a quote missing in your search string VBA complains
off
an "expected end of statement when the line is pasted and highlights the
second [ProjectName]


Regards
Joe

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched =
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe




:

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message I am using findfirst to locate records within my recordset. I would
like
the
record to be found only if the whole word exactly matches any word
within
the
sentence being searched. i.e.

String "Johnson Foodstore" returns false when searching for "John"
but
String "John Smith Foodstore" returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe

 

[Alex Dybenko]

ok, there were 2 extra ampersands
rstSearch.FindFirst "[ProjectName] Like '" & strsearch1 & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hi Alex

I maybe right but I cannot workout where the quote should go. Could you
re-post the correct search string.

Regards
Joe

yes, you right!

"Visio Candar Control" <[email protected]>
wrote
in message news:[email protected]...

Hi Alex
There appears to be a quote missing in your search string VBA complains
off
an "expected end of statement when the line is pasted and highlights
the
second [ProjectName]


Regards
Joe

:

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched
=
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe




:

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control"
<[email protected]>
wrote
in message
I am using findfirst to locate records within my recordset. I
would
like
the
record to be found only if the whole word exactly matches any
word
within
the
sentence being searched. i.e.

String "Johnson Foodstore" returns false when searching for
"John"
but
String "John Smith Foodstore" returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe

 

[JoeBo]

Hello Alex

благодарю Ð²Ð°Ñ Ð·Ð° помощь

JoeBo

ok, there were 2 extra ampersands
rstSearch.FindFirst "[ProjectName] Like '" & strsearch1 & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hi Alex

I maybe right but I cannot workout where the quote should go. Could you
re-post the correct search string.

Regards
Joe

yes, you right!

"Visio Candar Control" <[email protected]>
wrote
in message Hi Alex
There appears to be a quote missing in your search string VBA complains
off
an "expected end of statement when the line is pasted and highlights
the
second [ProjectName]


Regards
Joe

:

hi,
should be:

rstSearch.FindFirst "[ProjectName] Like '" & strsearch1& & "' or
[ProjectName] Like '" & strsearch2 & "'"

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control" <[email protected]>
wrote
in message Hello Alex

I have tried:


(both strsearch 1 & 2 declared as strings. The string being searched
=
"Johns Foodstore" the search string = "Johns"

strsearch1 = "* " & astrTemp(intRow)
strsearch2 = "* " & astrTemp(intRow) & " *"

with:

rstSearch.FindFirst "[ProjectName] = '" & strsearch1& & "' or
[ProjectName]
= '" & strsearch2 & "'"

Although I know the string exists the search fails.

Do you have any suggestions?

Regards
Joe




:

Hi,
you can try to search for %John %
with space at the end

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Visio Candar Control"
<[email protected]>
wrote
in message
I am using findfirst to locate records within my recordset. I
would
like
the
record to be found only if the whole word exactly matches any
word
within
the
sentence being searched. i.e.

String "Johnson Foodstore" returns false when searching for
"John"
but
String "John Smith Foodstore" returns true.

I have tried using wildcards but get to many unmatched returns.
Any help appreciated.
Joe