I have list with 500+ records. There is a hyperlink column called "TargetURL". As all of us know SP saves hyperlink in ["http://portal.site.com/sitecoll/doclib/Forms/someview.aspx", description ] format.
I have a workflow and I need to extract the doclib portion from the URL segment so I can get the document library name. Possible?
Substring? but how ? any tips will be appreciated.