Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Special Characters Using Function | Excel Discussion (Misc queries) | |||
Find Special Characters Using Function | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
Name Ranges: Function to convert special characters underscores | Excel Worksheet Functions | |||
Escape for special characters in string | Excel Programming |