Start a new topic

Regular Expressions Dictionary for Class of based on Date Graduated

We use a profile that an Omatic consultant built to convert our current students (already loaded into RE without their education information) to grads. The profile adds the education data. Our "Class of" field is based on the Date Graduated, but for our December 2020 grads, they are receiving class of 2020, but should be class of 2021. Our Class of logic is below. Can someone assist in ensuring our regular expressions logic matches the info below? 

 

I've attached a screenshot of the regular expressions logic and the JSON profile we're using.

 

Examples

  1. Graduated on 8/30/2020 is a 2021 grad
  2. Graduated on 12/1/2020 is a 2021 grad 
  3. Graduated on 5/1/2021 is a 2021 grad 

  1. Graduated on 8/30/2021 is a 2022 grad
  2. Graduated on 12/1/2021 is a 2022 grad 
  3. Graduated on 5/1/2021 is a 2022 grad 

  1. Graduated on 8/30/2022 is a 2023 grad
  2. Graduated on 12/1/2022 is a 2023 grad 
  3. Graduated on 5/1/2023 is a 2023 grad

json

In your example, there seems to be an inconsistency in the second set of 1,2,3 -- is a 5/1/2021 grad a 2021 grad or a 2022 grad?

Did it work in the past?  This might be something to take up with Omatic.

From looking at the dictionary, I'm not sure that the dictionary on its own would be able to do what you're wanting.

Regular Expressions are *really* difficult to read an interpret.  But it looks like the first part is replacing certain kinds of dates with -Blank-.

The second part, it looks like it's set to return the last two digits of the Graduated Date field -- so a two digit year.

But I don't see how that would achieve the goal you need.  What you need looks similar (different but similar) to the thing we have where we sometimes need to convert from Calendar Year (CY) to Fiscal Year (FY).  We need to add one to the year, conditionally, depending on what month of the year it is.

I don't believe there's a good way to do that in Regular Expressions.  I think you need VBA.


1 person likes this

Hi Isaac, thank you for taking the time to review! I really appreciate it. You're right, I fat-fingered one of the dates and the examples should read as:

 

1. Graduated on 8/30/2020 is a 2021 grad

2. Graduated on 12/1/2020 is a 2021 grad

3. Graduated on 5/1/2021 is a 2021 grad

 

4. Graduated on 8/30/2021 is a 2022 grad

5. Graduated on 12/1/2021 is a 2022 grad

6. Graduated on 5/1/2022 is a 2022 grad

 

7. Graduated on 8/30/2022 is a 2023 grad

8. Graduated on 12/1/2022 is a 2023 grad

9. Graduated on 5/1/2023 is a 2023 grad


Thanks for the recommendation to use VBA. I'll research that route and if you have any other tips or recommendations, I'm all ears. 


Thanks so much.

Login or Signup to post a comment