
Нужно Regular Expression или VBScript function (or combination of both) to check if the name is in a particular format.
Format: Lastname, Firstname - Last Name comma blank space First Name
for example:
Abbott, Sarah - True
Parker, Sarah Jesika - False (blank space after the comma)
Abdi-Ibrahim, Maymuna - False (dash)
Johnson, Mary & Cole- False (ampersand)
Archer, James & Colermant, Camilia - False (several names)
Заранее благодарна!