Hi,
I have a document library that i have the below extra columns:
1. Groupname (text)
2.Type (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:
(?<=-)[w ]+(?=)
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.
Thanks
