[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1536
  • Last Modified:

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.
0
Maheshkumar K
Asked:
Maheshkumar K
  • 2
  • 2
1 Solution
 
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 KAuthor 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
 
Maheshkumar KAuthor Commented:
Thanks Colly. I have implemented this using the Event Listener. But I am interested to achieve this using SPD Workflow
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now