asked on

How to split the SharePoint Document Library Column using SharePoint Designer Workflow

I am trying to split a string which is stored in a SharePoint2013 document library and I want to loop through this and put the document in to separate library based on the split value.

Eg.

List A(Document Library) - has the column called Candidates which has the values like (101,102,103) with some document attached to the list. Now I want to split that Candidate column and insert each value in to different library with the corresponding document.

colly92002

Download it to Excel, process it there, then create a new list from your Excel document.
Here is an example using Office 365 http://blog.blksthl.com/2014/01/15/office-365-guide-series-create-a-new-list-from-an-excel-spreadsheet/

Maheshkumar K

ASKER

Hi Colly,

I am not sure about the solution what you have given. Let me brief the problem again.

I have 2 document library, 1 Document Library has the pdf file uploaded with few metadata for eg.

Document Name      BUID        Cust Name
document1      101,102,103,104      abz

I want the above item inserted into another library like below:

Document Name      BUID      Cust Name
document1.pdf      101      abz
document1.pdf      102      abz
document1.pdf      103      abz
document1.pdf      104      abz

All these need to be done using SPD 2013 Workflow.

ASKER CERTIFIED SOLUTION

colly92002

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Maheshkumar K

ASKER

Thanks Colly. I have implemented this using the Event Listener. But I am interested to achieve this using SPD Workflow