RegEx formula for class year :

How can we help you today?

Start a new topic

RegEx formula for class year

Sara Kramer

started a topic almost 7 years ago

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

Wayne Pozzar

said almost 7 years ago

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+)/((?$)

(^\d+)/((?).*