Rons Place Blog - Home

Tag: Rons CSV Editor

Currently in progress: Rons Data Cleaner

    Aaron Stewart

We have a new product available for download on our website: Rons Data Cleaner.

It is still in the early stage of development, but we have been vigorously testing and resolving issues and bugs, so at this point only minor issues are expected. We have a solid list of features to add to Rons Data Cleaner in future releases, but if our customers are interested in shaping the application to their needs, now is the time to contribute and give us feedback.

The design of Rons Data Cleaner was derived directly from the various requests of many Rons CSV Editor users who, in...

"Unable to Check the License for Rons Place Software products" error message

Why receiving this message?

Rons Place Software products will check their license about once a month. This system has been put in place to prevent fraud or excessive installation of our licenses as well as to allow a potential future portable version of our products.

In most cases the check comes with no disturbance: our products connect and quickly check the version with our server and our users receive either one of the two following messages: "Version Checked!' or "A new version of X is available. Would you like to download it?". 

When a licensed product is not able to connect to our server however, the error message below pops up. Users cannot use the Pro version anymore, and with no license verification possible, our products revert to the LITE version.

A (temporary) poor internet connection can be the reason why the Rons Place...

To change the header in a CSV File

  • Using Rons CSV Editor, open or import the CSV file.
  • Go to the 'Column/Make Header Row' menu.
    • Or...
  • Go to the 'Column/Make Row Header' menu.
  • Save the file.

 

 

To remove or replace text easily 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:
    • Enter the text or character you want to be replaced or removed in 'Search For'.
    • Enter the text or character you want it to be replaced in 'Replace With', or leave this field blank if you want the text or character to be removed completely. 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.

 

A CSV (or comma-separated value) file is a text file containing data formated as a table. Each line represents a row and contains a list of cell values separated by commas. The first row can optionally contain the list of column names.

An example is shown below:

 

FirstName,LastName,Company
Portia,Mcfann,Beachcomber Realty
Andrew,Fenstermacher,Shafer Commercial Seating Inc
Brady,Tatum,Cywinski Jackson Bohlin
Gracie,Riskalla,Richard A Esq Jessup
Helga,Rio,Pony Express

 

Which when handled correctly represents:

FirstName LastName Company
Portia Mcfann Beachcomber Realty
Andrew Fenstermacher Shafer Commercial Seating Inc
Brady Tatum ...

Rather immodestly we think Rons CSV Editor is the best CSV editor. However we are the ones who created it so we don't actually expect anyone to believe us. For this reason we provide an 100% free Lite version of our software, and a free trial of the Pro version, so that our customers can make up their own minds in their own time.

 

 

Our Goals

We have aimed to make the job of editing CSV files as easy as possible by keeping in mind throughout design and testing that the Rons CSV Editor is for editing data tables, and that fundamentally our product is a text editor. Our customers have also played a key role in the...

Let's be clear. Excel is state of the art spreadsheet software, and is excellent at doing what it was designed to do. However, over the years Excel's table structure has led it to be used in ways for which it was not originally designed. One of these is editing CSV files, for which it is capable, but far from perfect.

 

Some of the main problems encountered with CSV files in Excel

Problem Description Effect
Excel not recognizing the comma. For English installations of Excel the comma (,) is recognized and used correctly as a field/cell separator. However in European installations of Excel the comma is used as the decimal point character and Excel uses a semi colon (;) as the field/cell separator. Every field in a row in a CSV file is loaded into the first column as a single...

 Rons CSV Editor for e-Commerce

Increasingly over the last few years we have noticed that a large portion of our customers are made up of people running e-commerce websites. Usually these sites are a based on a commercially available e-commerce platforms such as one of those shown below.

 

Next Page