Splitting Excel Columns by a Custom Delimiter

Overview

By using the Split Excel Column component in a Flow, the data in an Excel spreadsheet's column that is separated by a delimiter can be split into several columns and then displayed in a data grid or converted into a CSV file. 

Example

1. To begin, navigate to a Designer Folder and click the Create Flow button. 
2. Select and name the default Flow [Custom Delimiter] and click CREATE to open it in the Flow Designer. 
3. In the Flow Designer, expand the category All Steps [Catalog] > Integration > Excel and CSV, then drag and drop a Split Excel Column step to the workspace.
4. Connect the Split Excel Column step to the Start and End steps. 
5. To map the component, click on the Split Excel Column step and click the Edit Input Mapping button in the Properties panel, or select Show Mapping Editor from its Actions menu.
6. In the Mapping Editor, change all inputs from Unknown to Constant. 
7. For the File object, add the file using the file selector.
8. For the fileType object, from the Value drop-down list, select Excel_xlsx.
9. For the column object, specify the number of columns in the file in the Value field.
10. Enter the delimiter in the value field under the delimiter object.
11. Enter the relevant worksheet number, if working with a document created with multiple worksheets.
12. Finally, specify the number of columns that should result after the columns have been split (or merged).
13. Click OK to save the mapping and close the Mapping Editor.