Results 1 to 12 of 12

Thread: Regular Expression Construction Help[RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Addicted Member perlmonk's Avatar
    Join Date
    Jan 2005
    Posts
    138

    Resolved 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
  •  



Click Here to Expand Forum to Full Width