LinkBack URL
About LinkBacks
Snap108.jpg
VBScript.RegExp
-->VBA does not support look behind
How Should I need to create a regular expression?
Snap108.jpg
VBScript.RegExp
-->VBA does not support look behind
How Should I need to create a regular expression?
Last edited by chief_abound; 12-03-2015 at 03:05 AM.
VBA does support look from behind
its called instrRev
Please Login or Register to view this content.
Last edited by humdingaling; 12-03-2015 at 02:56 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
or using right instead
Please Login or Register to view this content.
Originally Posted by chief_abound
Please Login or Register to view this content.
Hi! humdingaling
Thank you very much!
Hi! jindon Thank you so much!
System.Text.RegularExpressions.Regex
-->.Net Framework regular expressions
Is it can be used in VBA?
Yes, You can use look behind in Net, but it is not linked to VBA despite both VBA and Net are owned and developed by Microsoft . I believe most of the syntax for VBA are similar to and might have derived from JavaScript .
If I am not mistaken, the earlier versions of Perl, which is the daddy of Reg expression, did not support Look behind.
Last edited by AB33; 12-03-2015 at 04:49 AM.
I don't think so in vba, so trying to find the way around most of the case...
Thank you. opinions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks