Ignore characters in field for webviewer help
I have a table prepopulated with statute numbers of the format 13A-5-191. I have a webviewer that will go to a webpage based on the statute number ("www.somewebsite.com/"&STATUTENUMBER&".htm"). This works great except that occasionally I have a statute that is of the format 13A-5-191(a)(2). I need the webviewer to ignore the first occurrence of "(" and everything after.
Ideas from the Guru's?
Thanks in advance,