+9Hi all,
Looking at migration of PDF documents to SharePoint. There is Data within the filename, eg. Property Number, FY, Created/Issued date.
Question, can FME populate the system Created date as the file is migrated/imported from the filename data? EG. Filename 12345_25-26_01012026.pdf
Any suggestion much appreciated.
Thank you
Tim
+62Yes, you can use the Directory and File Pathnames reader to read in a list of PDF files and then use either Regular Expressions, an AttributeSplitter or substring functions to extract the information you need from the filename.
Using your example, I would pick the AttributeSplitter, using _ as the separator character. It creates a list, with _list{0} being the property number, _list{1} the FY and _list{2} the date.
