Like Operator

[AlexanderBB]

Is there any way I can use Like to determine if a string starts with "[" and ends with "]"?

Or another (better?) method than left,1 and right, 1 ?

 

[Marcelo Branco]

Maybe...

Like "[[]*[]]"

M.

 

[AlexanderBB]

Many thanks Marcelo, that's what I was after !

 

[Rick Rothstein]

Maybe...

Like "[[]*[]]"

You can do it like this as well...

Like "[[]*]"

The left square bracket needs to be included inside of a the square bracket pair... the right square bracket can be used directly in the pattern string as above.

 

[AlexanderBB]

Even better. Thanks Rick. I nearly fluked this as I'd tried all sorts of similar things, but went wrong looking for a single escape char.

 

[Marcelo Branco]

Many thanks Marcelo, that's what I was after !

You are welcome. Glad to help

M.

 

[Marcelo Branco]

You can do it like this as well...

Like "[[]*]"

The left square bracket needs to be included inside of a the square bracket pair... the right square bracket can be used directly in the pattern string as above.

Curious. I did not know it was possible
Thanks for sharing.

M.