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.
Maheshkumar KTech LeadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

colly92002Commented:
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/
0
Maheshkumar KTech LeadAuthor Commented:
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.
0
colly92002Commented:
Have a look here and learn how to build a workflow, its not hard but there is a lot to do:
http://msdn.microsoft.com/en-us/library/office/jj163272%28v=office.15%29.aspx

If you want this to happen automatically when a document is added to library 1, then you could also use an event receiver rather than a workflow.  If you know c#/visual studio then this is actually probably easier to do than building a workflow.  Here is a simple example to get you started: http://onceinawhilescribble.blogspot.co.uk/2013/05/creating-simple-event-receiver-in.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Maheshkumar KTech LeadAuthor Commented:
Thanks Colly. I have implemented this using the Event Listener. But I am interested to achieve this using SPD Workflow
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.