Hello fellow Blazers! Looking for some ideas as to how would you go about this.
I am in Salesforce Lightning. I want Regex to look at the last name of a student, then based on the first letter of the last name, I want the snippet I insert to populate a name in a field that assigns a task to that user. Example:
Student Name: Oscar de la Hoya
Return the name below based on alpha-split:
Online VA Students (A-F): Reggis Metayer
Online VA Students (G-O): Dahly Jimenez
Online VA Students (P-Z): Vien Le Delgado
In the above example, based on the students name, Regex would need to return the name “Dahly Jimenez” because she is the person who works with students whose last name starts with letters “G” through “O”.
If the student name was Jason L. Bateman, then the name needing to be returned would be “Reggis Metayer”.
The unknown factor is how many words or characters make up the students full name. Some have just first and last name while others have a middle initial, or a multi word last name like “Neil Degrasse-Tyson”.
Hope this makes sense. Thank you!