Extract text from document name using calculated column

Question

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).

Answer 1

Instead of using LEFT and RIGHT, you could just use MID.

Returns "JUNK" from the KGlasier example.

=MID( [Doc Name], 10,4 )  

MID( string, startChar, numberOfChars )

Answer 2

To extract the metadata values from the Doc Name column you can use the =RIGHT(<TEXT>,<LENGTH>) and =LEFT(<TEXT>,<LENGTH>) functions. As long as the length of each metadata is the same (Where yyyymmdd.xxxx.xxxxxxxx.xxxx.xxxxxxxx is always of lengths 8.4.8.4.8) then these formulas should work...

// If [Doc Name] is 20180917.JUNK.JAZZLIKE.QUIZ.BLIZZARD

=LEFT(
   RIGHT(
      [Doc Name],
      LEN([Doc Name])-9
   ),
   4
)
// Returns JUNK

=LEFT(
   RIGHT(
      [Doc Name],
      LEN([Doc Name])-14
   ),
   8
)
// Returns JAZZLIKE

=LEFT(
   RIGHT(
      [Doc Name],
      LEN([Doc Name])-23
   ),
   4
)
// Returns QUIZ

=LEFT(
   RIGHT(
      [Doc Name],
      LEN([Doc Name])-28
   ),
   8
)
// Returns BLIZZARD