I have a batch of file names that follow this naming convention:
LastName_FirstName_DOB_ParentLastName_ParentFirstName.pdf
I need to remove the Parent Last Name and Parent First Name information from the file names. I can't utilize the Remove Last because all names will vary in character length. Is there anyway to remove characters after the _ by using a wild care or other setting?
Even if I have to take two passes... I need the final file name to be: LastName_FirstName_DOB.pdf
Thanks so much!
Toby