You’re offline. This is a read only version of the page.
I built several workflows in SharePoint designer that extracted information from the filename and tagged the file with the appropriate metadata.
For example:
Doe, John - 8Hr Safety Training Course 2021-08-26
When I built this in SPD, I used the location of '-' to figure out where to extract the person's name, the location of 'Hr' to extract the hours, extracted the date off of the end since it is always a fixed number of characters, and extracted the name of the course using the 'Hr' location and the fixed position of the date from the end of the string.
I have extracted the course hours and the person's name, but have not been able to extract a specific number of characters from the end of the string.
Hi @Anonymous
If you want to get the date from 'Doe, John - 8Hr Safety Training Course 2021-08-26',you can refer to:
Expression:sub(length(outputs('Compose')), 10)
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
462
