I don't know how to study Regular expression.Please advise
I don't know how to study Regular expression.Please advise
i found it surprisingly hard topic to find information about
here's a link which i found very helpful
http://stackoverflow.com/questions/2...cell-and-loops
after which you can go here
http://www.regexr.com/
*note* not all features from this site work in Excel's version REGEX
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.
Reg Exp is generally a hard topic to get your head around..
I'v used it many times, but I still haven't understood how the Expression is built (Which really is the only complex part)
I normally use this link to create expressions and check if it is right.
http://www.regexr.com/
Some Helpful Links -
http://www.aivosto.com/regexpr/help/syntax.html
http://www.aivosto.com/vbtips/regex.html
http://www.aivosto.com/regexpr/help/tutorial.html
https://blog.udemy.com/vba-regex/
http://www.excelforum.com/excel-form...ml#post4046220
https://support.office.com/en-gb/art...8-85b0ad1c427f
http://www.regular-expressions.info/tutorial.html
Cheers!
Deep Dave
Hi humdingaling
Sorry.I didn't know that my questions were difficult subjects.Thank you for your giving information.
Hi NeedForExcel
Sorry.I didn't know that my questions were difficult subjects.Thank you for your giving information.
its actually not that difficult once you understand the basic syntax
after which it is pretty much trial and error
Just search the web.
Keywords...
VBA Regular Expression Meta character
You've been a great help. Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks