I need to parse out filenames into two fields - first and last name. For example, if the filename is 400_AmySmith.jpg, I would like 'Amy' to be populated in the field FirstName and 'Smith' to be populated in the field LastName. While all filenames will have the extension .jpg, not all filenames start with the same leading number (in this example 400) but they do all start with a number and then underscore before the model name.
Is there a simple way I can achieve the above? Thanks!