How To Split Rows in a CSV File - Rons Place Articles

   

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 our CSV Editor, 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

    Window_Merge_Rows 1

    Window_Merge_Rows 2

    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 orginal 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.


Tags: Rons Data Edit
Our Products

Rons Data Edit - Modern CSV Editor

Learn more

Rons Data Stream - Powerful Data Processing

Learn more

Rons CSV Editor - Professional CSV Editor

Learn more

Rons WebLynx - Desktop Bookmark Manager

Learn more

Rons HTML Cleaner - Easy HTML Processing

Learn more

Rons Renamer - Powerful Batch File Renamer

Learn more