Extract text from a file string
Simple question (I hope).
I have a list of document locations - that look like this:
_Central Documents/Training/Investigators/Rhodes, Meredith/CV
I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column.
What is the basic formula to get this done?
Help Article Resources
Check out the Formula Handbook template!