CSVfix 1.6

Neil Butterworth in Servers / Other Server Applications

User Rating: 2.8 (29 votes)

If you have any dealings at all with data and databases, then you almost certainly will have have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text processing tools like sed, awk and perl on CSV files is not as simple as it might be.

FEATURES:

· Convert fixed format, multi-line and DSV files to CSV
· Reorder, remove, split and merge fields
· Convert case, trim leading & trailing spaces
· Search for specific content using regular expressions
· Filter out duplicate data or data on exclusion lists
· Perform sed/perl style editing
· Enrich with data from other sources
· Add sequence numbers and file source information
· Split large CSV files into smaller files based on field contents
· Perform arithmetic calculations on individual fields
· Validate CSV data against a collection of validation rules
· Convert from CSV to fixed format, XML, SQL, DSV
· Summarise CSV data, calculating averages, modes, frequencies etc.

File Size: 737 kB License: Freeware Price: FREE
Platform: Windows XP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64
Downloads: Total: 155 | This Month: 10 Released: 2014-10-13
CSVfix Similar Software

CSV Loader 2.2 Adrian Wijasa    

CSV Loader is a useful and easy-to-use Java-based application that can help you load Excel CSV files into Oracle, MySQL, and PostgreSQL relational databases. Using CSV Loader, you can prevent the need to relearn ... features of "CSV Loader": Load an Excel CSV file into Oracle, MySQL, or PostgreSQL Insert new .... Free download of CSV Loader 2.2

CSVExporter 2.2 Kim Beros Consulting Pty Ltd    

... 95% of data applications support the import of CSV and delimited text files why complicate things. With ... exporting Lotus Notes information in minutes. Export to CSV and text delimited format. Then simply import into ... capable of! Features: Export to: · CSV · Delimited Text · Specify Delimiters · Exports .... Free download of CSVExporter 2.2

software pick   

Cyber-D’s SQL Wizard 2.01 Dario Volaric    

... makes it easy to generate SQL queries from CSV data. This tool is ideal for people who need to insert large amounts of data into an SQL database. If you always receive Excel documents and need to insert the data into an SQL database, then this tool is ideal. Simply .... Free download of Cyber-D’s SQL Wizard 2.01

ADSLMExport 2.3.0 Upscene Productions    

... formats (XLS, DOC, RTF, HTML, XML, DBF, TXT, CSV, DIF, SYLK, SQL, LaTeX, PDF). .... Free download of ADSLMExport 2.3.0

EMS Data Export 2011 for SQL Server 3.7.2 B50001 EMS Database Management Solutions, Inc.    

... Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. The program supports Unicode ... MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, ODF, SYLK, DIF, LaTeX, SQL, Clipboard and others Exporting data from several tables, views or queries at the same time Unicode data support Selecting .... Free download of EMS Data Export 2011 for SQL Server 3.7.2 B50001

Popular Software in Servers / Other Server Applications

PHPRunner 10.0 B31851 Xlinesoft.com     update

Database driven PHP web site with no programming. Free download of PHPRunner 10.0 B31851

software pick   

Portable RazorSQL 8.1.1 Richardson Software, LLC     update

Can help you query, update, navigate, and manage all major databases. Free download of Portable RazorSQL 8.1.1

software pick   

SQLyog Pro x64 12.5.1 Webyog, Inc.     update

Created to provide users with a means of administering MySQL databases. Free download of SQLyog Pro x64 12.5.1

Navicat Lite for Oracle 12.1.9 PremiumSoft CyberTech Ltd.     update

A GUI for Oracle server administration and development. Free download of Navicat Lite for Oracle 12.1.9

software pick   

SQL Examiner Suite 7.1.6.195 TulaSoft, LLC     update

Compares and synchronizes database schemas and contents. Free download of SQL Examiner Suite 7.1.6.195