|
-
Jan 11th, 2005, 03:58 PM
#1
Thread Starter
Addicted Member
Regular Expression Construction Help[RESOLVED]
I'm using VBA for excel, and Im facing a problem.
I have a string, for example abcde
If the string (data in a cell) is as above, then its OK. Sometimes, the data recieved might have some apostrophes (") at the beginning or end. To capture this, I want to pattern match against every cell to account for the following strings
"abcde
abcde"
"abcde"
In all the above, the output shud be abcde. I found a lot of websites detailing out pattern matching for VB, but, I believe that its not the same for VBA for excel. For example..." are referred to as chr(34) as I recently dicovered.
If someone could help me build the regex im looking for...I'd really appreciate it!!
Last edited by perlmonk; Jan 13th, 2005 at 12:45 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|