I need to isolate parts of a document name so that the workflow (SPD 2010) can update respective metadata fields.
Doc Name is within the following format : yyyymmdd.xxxx.xxxxxxxx.xxxx.xxxxxxxx
The need is to extract 3 metadata fields within the name of doc shown above. I want to create calculated columns to go about doing this but getting stuck. I know that we can use string functions, however, the find string within string function is not available via SPD 2010 wf's and our current 2013 version is not working (ticket open with MS but client needs workaround).
yyyymmdd.xxxx.xxxxxxxx.xxxx.xxxxxxxxformat all the same length (eg, is the second metadata always 4 characters, and the third matadata always 8 characters?