+ Reply to Thread
Results 1 to 7 of 7

Regular Expression to get a string between parentheses in VBA

  1. 10-12-2015, 10:50 PM #1
    chief_abound
    chief_abound is offline
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Regular Expression to get a string between parentheses in VBA

    ??? 1.jpg

    formula --> =SUBSTITUTE(REPLACE(A1,1,FIND(")",A1)+1,""),")","")

    Regular Expression?
    Attached Files Attached Files
    Last edited by chief_abound; 10-12-2015 at 11:08 PM.
    Reply With QuoteRegister To Reply
  2. 10-12-2015, 11:14 PM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,517

    Re: Regular Expression to get a string between parentheses in VBA

    Try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-12-2015, 11:20 PM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Regular Expression to get a string between parentheses in VBA

    Hi,

    Here is a User Defined Function (UDF) that may do what you want.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 10-12-2015, 11:23 PM #4
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Regular Expression to get a string between parentheses in VBA

    Hi Chief,

    You may also try this
    Please Login or Register  to view this content.
    1. Thank those who have helped you by clicking the Star * below the post.
    2. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Sincerely,
    Farid
    Reply With QuoteRegister To Reply
  5. 10-13-2015, 12:18 AM #5
    chief_abound
    chief_abound is offline
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: Regular Expression to get a string between parentheses in VBA

    Hi jindon. Thank you so much

    You're been a big help
    Reply With QuoteRegister To Reply
  6. 10-13-2015, 12:20 AM #6
    chief_abound
    chief_abound is offline
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: Regular Expression to get a string between parentheses in VBA

    Hi MarvinP.It is very courteous of you to help me.
    Reply With QuoteRegister To Reply
  7. 10-13-2015, 12:21 AM #7
    chief_abound
    chief_abound is offline
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: Regular Expression to get a string between parentheses in VBA

    Hi Faridwahidi

    Thank you very much indeed.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Regular expression
    By Gourav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 03:23 PM
  2. Regular Expression - String comparsion
    By VBA-Snail in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 02:25 PM
  3. Regular Expression Pattern All Letters In String
    By goss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-05-2013, 12:13 AM
  4. [SOLVED] Find a string by VBA Regular Expression and replace a part of that string
    By taps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-25-2013, 11:08 AM
  5. Can't change case of string matched by regular expression in VBA
    By mthomps2 in forum Excel General
    Replies: 0
    Last Post: 10-04-2012, 04:16 AM
  6. Using a regular expression to pull out data from a string
    By mundo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2008, 07:42 AM

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1