View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vagabond Software Vagabond Software is offline
external usenet poster
 
Posts: 3
Default String Function 'Like' and Special Characters

I'm trying to find string values that start with a bracket ("[") character. However, I know the bracket character serves a special purpose in regular expressions and string functions.

For example, the first rKeyName.Value is "[paths]", but in the following code snippet; the IF statement produces an error and all combinations of apostrophes, quotes, and backslashes that I have tried don't match "[paths]".


VB:
------------------------------------------------------------------------------
For Each rKeyName In rKeySection
If rKeyName.Value Like "[*" Then
strKeySection = rKeyName.Value
Else
strKeyName = rKeyName.Value
strKeyValue = rKeyName.Offset(0, 1).Value
oConfigData.Add strKeySection, strKeyName, strKeyValue
End If
Next
------------------------------------------------------------------------------


Thanks in advance,

Carl