aspose file tools*
The moose likes Java in General and the fly likes parsing a column in Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "parsing a column in Access" Watch "parsing a column in Access" New topic
Author

parsing a column in Access

Charles Diskin
Greenhorn

Joined: Mar 03, 2006
Posts: 19
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

Joined: Sep 20, 2005
Posts: 381
Cross posted http://www.coderanch.com/t/379433/java/java/parsing-column-Access
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31054
    
162

Thanks Max. Since this thread is in the right place we can continue discussion here. I added a note to the other one.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31054
    
162

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

Joined: Mar 03, 2006
Posts: 19
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

Joined: May 26, 2003
Posts: 31054
    
162

Charles,
Now that this question is about regular expressions, I'm moving it to our Java in General forum for you.
Charles Diskin
Greenhorn

Joined: Mar 03, 2006
Posts: 19
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

Joined: Jan 17, 2006
Posts: 1296
I'm not sure if this totally meets your requirements, but something like this should work.


Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peter
Charles Diskin
Greenhorn

Joined: Mar 03, 2006
Posts: 19
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!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: parsing a column in Access