Hello all, I am trying to parse out words in an access column that relate to web developement (*.java, *.html, *.jsp). If the column contents reads "Changed alog.java, must change filename" after the parse it should only display "alog.java", if anyone has any ideas please share. Thanks!
Charles, That sounds hard to do in SQL. I think you would be better off just returning the row and having Java parse it.
Joined: Mar 03, 2006
thanks for posting back so quickly, by now it seems like reawakening this post, sorry I was on vacation for a week now I have to dig back in and try to figure out this parsing problem. I have heard that using a regular expression may help me to identify the different file extentions such as .jsp, .java, etc. and maybe I could use trim to search back for white space at the begining of the file name such as "file.jsp", anyone have any ideas on how to go about creating a regular expression to do that or any other ideas how I could get this to work. Thanks in advance.