I have a document library that i have the below extra columns:
1. Groupname (text)
3. Location (text)
4. Date (Date only)
When a user uploads a file the above columns should be updated based on the extracted text from the filename.
I'm trying to extra the text from filename that is separated by "-" symbol.
My filename will have the following format:
Groupname-Type-location-date.pdf (extension can be docx or any other file extension)
Date will be in format: ddmmyy (no symbols in between)
I was able to extract the first & second part but not the rest.
1. For the first part (GroupName)i use the below code:
2. For the second part (Type) i used the below code:
Any body can help me how to extra the rest 3rd and 4th part?
I'm not sure if it's correct but for each part i'm using a separate "regular expression" box in nintex workflow.
Solved! Go to Solution.
@andreasc It may be easier to first do a split function, then you will have each part as an item in the collection and you will just have to remove the file type from the last entry using regex.