Like expression giving wrong result

[AlexanderBB]

x= "some text [2.02 stereo CD] more text"
? x Like ("*" & Chr$(91) & "* mono *" & Chr$(93) & "*")
True
But should be false. I do want the square brackets and spaces included.
Problem seems to be the square brackets. Can they be escaped ? Or some other fix?

 

[Micron]

I think not enough info for a solution yet. Maybe you can use Instr()? Depends on what you're really looking for. Is it [ ] or is it 2.02 stereo cd, or [2.02 stereo cd] or something else?

 

[AlexanderBB]

The example is [2.02 stereo cd]
I'm using Instr now while developing but it won't be correct if the key words also appear in some other text.

 

[Micron]

I think your problem is the inclusion of several characters/strings in the comparison. Like will return a match if you include [ in the search and [ is in the string. If you want spaces and brackets to be considered, that means you need to identify the exact pattern you need, because Like is based on pattern matching.
This returns True because the pattern match includes a left bracket:

x = "some text [2.02 stereo CD] more text"
If x Like ("*[mono]*") Then
    MsgBox "true"
End If

This returns False because the pattern match does not include a left bracket:

x = "some text [2.02 stereo CD] more text"
If x Like ("*mono*") Then
    MsgBox "true"
End If

Perhaps if you posted examples of inputs and expected results it would help anyone to help you.

 

[AlexanderBB]

The text string to test has space-mono-Space or space-stereo-space inside square brackets.
The output is True or False.
Msg1 had an example where True was returned and it should have been false.
Maybe a Ref Ex pattern would be better ?

 

[Fuji]

You need to escape by adding [] like

x Like "*[[]* mono *[]]*"