Search text with accents and unaccented uppercase and lowercase.

[marreco]

I need to do a search through a textbox, but when it is necessary that the search, it will be accepted texts with one hundred percent free, uppercase and lowercase.


example:
The records in the worksheet was done this way: mike gate.


when I search I would like to enter as well.


MIKE GATE, mike gate.


and returns the result in my search mike gate.


example2:
The records in the worksheet was done this way: josé landmarks.
I must return josé landmarks even if I type in the textbox like this: JOSE MARCOS, or jose marks (without Seat ').


this is possible?

 

[JLGWhiz]

I need to do a search through a textbox, but when it is necessary that the search, it will be accepted texts with one hundred percent free, uppercase and lowercase.


example:
The records in the worksheet was done this way: mike gate.


when I search I would like to enter as well.


MIKE GATE, mike gate.


and returns the result in my search mike gate.


example2:
The records in the worksheet was done this way: josé landmarks.
I must return josé landmarks even if I type in the textbox like this: JOSE MARCOS, or jose marks (without Seat ').


this is possible?

Example 1 is easy enough. Assume the search range is B2:B50
Sample Code:
Dim c As Range
For Each c In Range("B2:B50")
If UCase(c.Value) = "MIKE GATE" Then
MsgBox LCase(c.Value)
End If
Next
The message box would return "mike gate", No matter what letters were capitalized.
Example two would be a little more difficult to handle with any degree of certainty, at least for me it is, because the only method I can think of immediately is to use wild cards. Something like this.
Example Code:
Sub t()
Dim c As Range
For Each c In Range("B2:B50")
If UCase(c.Value) Like "JO*MAR*" Or UCase(c.Value) Like "JO*E *MAR*" Then
MsgBox c.Address & " could be Jose Landmark"
End If
Next
End Sub

 

[Rick Rothstein]

example2:
The records in the worksheet was done this way: josé landmarks.
I must return josé landmarks even if I type in the textbox like this: JOSE MARCOS, or jose marks (without Seat ').

If you want a solution to your problem, you are going to have to explain to us... in detail... the rule you are following that allows JOSE MARCOS (or jose marcos) to match josé landmarks. Would, for example, jose land match it? How about jose manville?

 

[marreco]

I wish my textbox, when it entered the names that were sought for the listview, all names in the worksheet rerenre digitdo that name in the textbox.






example:
Textbox1 = maria


If you are in my spreadsheet as well.


MARIA
maría
maria
should appear in the listview three names, not just the maria.

 

[Rick Rothstein]

I wish my textbox, when it entered the names that were sought for the listview, all names in the worksheet rerenre digitdo that name in the textbox.

example:
Textbox1 = maria

If you are in my spreadsheet as well.

MARIA
maría
maria
should appear in the listview three names, not just the maria.

I understand the first name match (ignore accents on letters), that is not a problem, but I do not understand the last name match at all. You said this...

"I must return josé landmarks even if I type in the textbox like this: JOSE MARCOS, or jose marks (without Seat ')."

Why is "MARCOS" a match for "landmarks" ???
Why is "marks" a match for "landmarks" ???

Can you explain why those last names match?

 

[marreco]

Hi.Rick Rothstein

disregard the last name.
I must have expressed myself wrong
thank you!