+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.
+9Yes, 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.
Thanks for your reply.
Can this data be sent to SharePoint as Metadata fields on import for each record?
Regards
Tim
+62Yeah, you should be able to do that (note that I don’t work with SharePoint myself so I don’t have first-hand experience). There’s a good article here that looks like it could be useful to you.
