By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| FILENAME | StudentID |
|---|---|
| Smith John D, 11-23-1980, 1234567.pdf | 1234567 |
| Doe Jane, _01_22_1980_123456.pdf | 123456 |
| John Doe, 567891.pdf | 567891 |
| FILENAME | StudentID |
|---|---|
| Smith John D, 11-23-1980, 1234567.pdf | 1234567 |
| Doe Jane, _01_22_1980_123456.pdf | 123456 |
| John Doe, 567891.pdf | 567891 |