• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

parsing a column in Access

 
Charles Diskin
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34648
364
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Max. Since this thread is in the right place we can continue discussion here. I added a note to the other one.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34648
364
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Charles,
That sounds hard to do in SQL. I think you would be better off just returning the row and having Java parse it.
 
Charles Diskin
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Charles
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34648
364
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Charles,
Now that this question is about regular expressions, I'm moving it to our Java in General forum for you.
 
Charles Diskin
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks again for the move, I am still having a heck of a time trying to get this to work. Anyone out there know of a regular expression that might recongize file names with extensions??
 
Garrett Rowe
Ranch Hand
Posts: 1296
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure if this totally meets your requirements, but something like this should work.
 
Charles Diskin
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Garrett, Thank you so much, that's exactly what I needed!! I was able to plug in the real data and it's working great. Thanks alot!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic