8 Replies Latest reply: Aug 5, 2015 7:58 AM by Sunny Talwar RSS

    How can I create a new field from existing data in the Data Load Editor?


      I am loading an Excel file from SharePoint with around 50 columns of data and around 7,000 records. One of the data fields is named 'Fiscal Year and Quarter' and contains 11 characters, ie 'FY2015 Qtr3'.

      I need to extract just the first 6 characters from this field, ie 'FY2015', and not the Quarter, and I want to create a new field named 'Fiscal Year' containing these 6 characters.

      Can someone please let me know how I can set a command in the Data Load Editor to do this?