Rons Place Blog - Home

Tag: Rons CSV Editor

Introduction

Rons CSV Editor can be configured to open any format of tabular text file, including the most commonly known format, comma separated value (or CSV) file. The Editor needs to process text into a tabular form when text data enters and exist the application, which happens in three ways:

  • Loading and saving a file.
  • Importing and exporting a file, or clipboard.
  • Copying and pasting data.

Configuring the delimiters (or separators) for loading and saving a file, and copying and pasting data are done in two separate windows, as they a both slightly different operations. Configuring the separators from importing and exporting is done in the import window.

Configuring Separators for Loading (file Associations)

Rons CSV Editor can store the separator settings for any file types that Windows can open with the Editor. The most common of course is ‘.csv’ but there are some common...

To Remove Duplicates in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Row/Remove Duplicates' menu.
  • Apply the appropriate settings:
    • Rows to be compared should display in the 'Selected Columns' section.
    • Click on 'Proceed'
  • Save the file.

 

 

To Merge Rows in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Row/Merge' menu.
  • Apply the appropriate settings:
    • Choose 'Selected Rows' or 'All rows'
    • Select the columns sections to be merged
    • Select the separator required
  • Click on Merge.
  • Save the file.

 

 

 

To Merge Columns in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Column/Merge' menu.
  • Apply the appropriate settings:
    • Select the columns to be merged and transfer them to the Source...

To Split Rows in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Row/Split' menu.
  • Apply the appropriate settings:
    • Select the rows to be split or select All rows.
    • Select appropriate column.
    • Indicate where it must be split on the 'Split on' section.
    • Indicate if the new row must keep the source info or not.
  • Click on 'Split'.
  • Save the file.

 

To split Columns in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Column/Split' menu.
  • Apply the appropriate settings:
    • Select the Source...

To use templates to Edit CSV Files

Editing CSV files often turns out to be a repetitive job, for example updating product lists regularly in an ecommerce application. The use of templates can gain tremendous time and are very easy to set up. Templates can be used in Rons CSV Editor in diverse ways:

Templates can be used:

  • To create a new file, using the columns in the template.
  • Apply structural formatting to the columns in an existing CSV file (in the 'Edit Columns' window).
  • Apply visual formatting to the columns in an existing CSV file (in the 'Column Layout' window).

How to create a new template

  • Go to the 'Tools/Manage Template' menu.
    • Click on New.
    • Create a Name.
    • Select the Name and click on Edit.
    • Click on Add to create your template.
    • Enter the appropriate information in the section on the right.

To remove spaces in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'View/Toolbox' menu to open the Toolbox.
  • Go to Remove and Space on the left side menu.
  • Apply the appropriate settings:
    • Centre Action: Select 'Remove'.
    • Select either 'Whole Document' or 'Selected Cells'(after manual selection). Found matches are highlighted on the preview and can be navigated through by clicking on the arrows next to the Update button.
    • Click on 'Update'.
  • Save the file.

 

To fill blank cells, rows or columns in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'View/Toolbox' menu to open the Toolbox.
  • Go to Find/Replace and Text on the left side menu.
  • Apply the appropriate settings:
    • Leave the 'Search for:' section empty.
    • Enter the text to fill the cells in the 'Replace with:' section. Found matches are highlighted on the preview and can be navigated through by clicking on the arrows next to the Update button.
    • Click on 'Update'.
  • Save the file.

 

 

 

 

Previous Page | Next Page