Start a new topic

RegEx formula for class year

I am attempting to import graduates and we set up a dictionary in training to convert class year based on graduation date (11/16/2009 0:00). It worked successfully during training and after training, I did a big import and was successful. It doesn't seem to work now and my knowledge of Regular Expressions are very limited. Can you help? This is the current expression: (^\d+)/((?


Thanks!

1 Comment

It looks like this dictionary is assuming that there is no time in the date.  It works for 11/16/2009

In order to make it also handle a time (i.e. ignore the time if it is there) you should change the expression

 

From

(^\d+)/((?$)

To

(^\d+)/((?).*
Login or Signup to post a comment