How To Split Rows in a CSV File
To Split Rows in a CSV File
Step 1: Open your file with a dedicated CSV Editor - Rons Data Edit
First things first, make sure you use the correct application to edit your CSV files; you can download Rons Data Edit, for free, right here: Download.
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
|
Description |
Options |
Explanation |
| Tools Available | Several tools are displayed. 'Split Rows' should be selected. | |
| Split Row on | ||
| Split Column | Column List | Select the column where the splitting of the data will result into the creation of a new row. |
| Split on | Text | 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). |
| Regular Expression | When selected, the regular expression can be typed in the dedicated field below and it will determine the area where the split will occur. | |
| Tab | When selected, the row(s) will be split at the level of Tab separations. | |
| Line Break | When selected, the row(s) will be split at the level of Line Break separations. | |
| Options | ||
| New Row Action |
Copy Source Row |
When checked the content of the source row will be copied. |
| Leave Empty | When checked the content of the source row won't be copied so the cells will be empty. | |
| Apply to | ||
|
Whole Document |
Changes will be applied to the entirety of the current document. |
|
|
Selection |
Changes will be applied to the selected cells in the current document. |
|
Finally
Do you have a question, or some feedback? We'd love to hear from you! Send us, Rons Place Software, a message using our Contact Form and we will get back to you shortly.
