a nursing informatics toolbox

CSVed- The Better CSV Editor

Posted on August 7, 2011 by Rolando Cabral • 25 Comments

csved screenshot

Anybody familiar with CSV files or comma separated values or comma delimited files, etc.?

According to Wikipedia

The comma-separated values (CSV) pseudo-file[1] format is a set of file formats used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor. In fact, because the goal of reading and writing the format take precedence over consistency; there effectively is no “CSV standard”[2]: only the understanding that plain text is delimited by a symbol. Traditionally, lines in the text file represent rows in a table, and commas indicate the columns.

So, what’s in it for us?

Most data upload tools that electronic medical records use are either in modified excel or .csv format. It can also be found in some reporting applications’ output like Crystal Reports. As a clinical analyst (nursing informatics), I always encounter these file types and without a proper tool to decimate these mind-numbing alphanumeric concoction, you will end up cross-eyed by the end of the day.

Excel supports it but its capability is very limited in handling the special and complicated setup of this file type..

Introducing CSVed!

CSVed is an easy and powerful CSV file editor, you can manipulate any CSV file, separated with any separator.

some features:

  • edit, add, insert and delete items;
  • import;
  • change separator;
  • add, delete columns;
  • rearrange column order;
  • save selection of rows and columns;
  • save filtered items;
  • save with double quotes;
  • search and replace;
  • filter items;
  • remove duplicates;
  • append and merge files;
  • install and uninstall
  • help in English
  • add prefix and suffix
  • split and join columns
  • export to HTML, Excel, Word, XML and more
  • proper words and strings
  • column search
  • column sort and global sort

The listview is running in virtual mode, that means the data is displayed on demand. (not the entire CSV file is loaded in the listview) so CSVed can handle big files and is very fast.

Now, make your Nursing Informatics life easier by downloading this app!

get it from HERE!

Filed Under: Tips