To Split Rows in a CSV File
Step 1: Open your file with a dedicated CSV Editor - Rons Data Edit
Your CSV file can be opened using the 'Open Document' File menu, or 'Open Document' link on the Start Page of the application.
Step 2: Open the Toolbox and go to the 'Split Rows' Tool
In the ribbon bar, at the top of the main window, go to the 'Rows' tab, and click on the 'Row Tools' button. This action opens the 'Row Tool' pannel. From the available tools displayed, select 'Split Rows'.
Step 3: Set the appropriate 'Split Rows' options
See below for the listing of the settings and their explanation.
In this example above (see pictures), the user would like to split rows that have two names in the "First Name" column (Andrew and Sally). The goal is to create a new row immediately under the split row with the second name (Sally) as new "First Name" column content and keep the rest of the row with the same data as the original one.
Therefore, the row is split at the level of the "First Name" column, is split on text " and ", copying the Source Row data so that the rest of the data remains identical to the original row, and finally this action is requested on the Whole Document.
Step 4: Apply the changes
Click the 'Split Rows' button to apply the changes.
Step 5: Save the File
When satisfied with the changes, make sure to save the document by clicking on the 'Save' button the top left corner of the main window or by clicking the 'Save' button on the 'Home' tab of the ribbon bar.
Note: any action can easily be reverted by clicking on the 'Undo' button on the menu on the top left corner of the main window.
The Split Rows Tool Settings
|Several tools are displayed. 'Split Rows' should be selected.
|Split Row on
|Select the column where the splitting of the data will result into the creation of a new row.
|When selected, the text can be typed in the dedicated field below. As a consequence the row(s) will be split at the level of the typed in text when detected. That text won't be included in the new row(s).
|When selected, the regular expression can be typed in the dedicated field below and it will determine the area where the split will occur.
|When selected, the row(s) will be split at the level of Tab separations.
|When selected, the row(s) will be split at the level of Line Break separations.
|New Row Action
Copy Source Row
When checked the content of the source row will be copied.
|When checked the content of the source row won't be copied so the cells will be empty.
Changes will be applied to the entirety of the current document.
Changes will be applied to the selected cells in the current document.