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

Posted on 2014-08-04
Last Modified: 2014-08-09
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.


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.
Question by:Maheshkumar K
    LVL 15

    Expert Comment

    Download it to Excel, process it there, then create a new list from your Excel document.
    Here is an example using Office 365

    Author Comment

    by:Maheshkumar K
    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.
    LVL 15

    Accepted Solution

    Have a look here and learn how to build a workflow, its not hard but there is a lot to do:

    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:

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now