I'm trying to fill the Date of Birth (DOB) field from a pattern match for large batches of scanned student files. The files have come to me with multiple naming conventions. The DOB/file name is formatted as
(\d{1,2}[-]\d{1,2}[-]\d{4})[_]\D+[_]\D+[_]\D+[_][J][R] in some documents and
it is formatted as (\d{1,2}[-]\d{1,2}[-]\d{2})[_]\D+[_]\D+[_]\D+[_][J][R] in others.
How can I get the birthdates in the file names to populate my DOB fields? I'm using pattern matching for Last, First, Middle, and Suffix. The DOB field is formatted as / / .
Thanks!
John