I have an Access with a VB function that can find a sub-string from a long string using regular expression. However, it can only return the first matched sub-string in the return.
I would like to start from the attached sample Access with the stated function.
1) I want to build an Access that can extract all possibles sub-string(s) from a input long string that matched the designed regular expression.
2) All extracted sub-string(s) join together with "," as delimiter
3) VB script should be able to handle LONG string input which is LONGER than 255 char (Remark: VB script can only handle short string (MAX 255 char only))
4) In your proposal, please briefly describe your methodology and expected working hour that you will be used in the project to return all matched sub-string(s).
22 freelance font une offre moyenne de $292/heure pour ce travail
Hi! I think I have a solution for this. I've changed your code a bit and I got results (multi-matches). Start a chat please and I will send you a screenshot of what I get. Regards, Branislav Mihaljev
Hi. Great app writer for your projects. I have writen access, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile