AnsweredAssumed Answered

Parsing filename from insert and setting corresponding fields

Question asked by talkersw on May 8, 2017
Latest reply on May 8, 2017 by philmodjunk

Hi all. This is pretty simple to understand. I have a filename to insert into the container that will have a naming convention such as:


"name1_type_date" ...each value between the underscores has a corresponding text field on the layout


When I insert the file into the container, I would like to parse out each of the values separated by "_" and set them in the 3 corresponding fields on the layout.


For example:


Uploaded filename is: sam_contract_9_22_2017

Set name1: Sam

Set type: contract

Set date: 9/22/2017


I already have it modifying the filename on the insert to build the name from these fields when populated, but I also want it to work the reverse way so that someone can quickly get everything entered just from uploading the files.