parsing a column in Access

[Charles Diskin]

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]

Cross posted https://coderanch.com/t/379433/java/java/parsing-column-Access

[Jeanne Boyarsky]

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]

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]

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]

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

[Charles Diskin]

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]

I'm not sure if this totally meets your requirements, but something like this should work.

import java.util.regex.Pattern;
import java.util.regex.Matcher;
public class RegexTest3
{
   public static void main(String[] args)
   {
      String testString = "Changed alog.java must change filename" ;
 
      /**
      * Match or more word characters followed by a '.' followed by one or more
      * word characters, and capture the extension
      */
      String regex = "\\w+(\\.\\w+)";
 
      Pattern pattern = Pattern.compile(regex);
      Matcher matcher = pattern.matcher(testString);
 
      while (matcher.find())
      {
         String wholeMatch = matcher.group();
         String extension = matcher.group(1);
 
         System.out.println(wholeMatch + "\t" + extension);
      }
   }
}

[Charles Diskin]

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!!