AnsweredAssumed Answered

Parsing Text

Question asked by bHouston on Jul 5, 2018
Latest reply on Jul 6, 2018 by jormond

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!