3 Replies Latest reply: Jan 22, 2015 11:05 AM by Joseph Simmons RSS

    parse file name of varying length to make field values

    Steve Lord

      Hi, I have a heap of files named like this lastname_firstname.pdf

       

      Since they are pdfs, I can't load the contents of the files (to my knowledge).  The request is simply for a view of the list of the files so reps can see whose files we've received.  I could just load filename() as filename and sort alphabetically, but I would like to make a couple of clean fields for first name and last name for ocd/tidiness reasons.

       

      I feel like the answer is in my head or on a qvw I have somewhere, but if someone can hit me with the function here real quick it'd save me time rummaging around and get you some easy correct answer credit.   (and be helpful to others with similar questions.)