Cisco HTML WSUS Android (1)
Bootstrap (1)
Certification (3)
Cisco (1)
Database (3)
Development (2)
Digital Photography (1)
Freeware (2)
General (14)
git (1)
HTML (2)
Javascript (1)
Linux (6)
MCSE (3)
Microsoft (6)
MySQL (2)
Network (4)
Office Suite (2)
Oracle (1)
PHP (2)
scripting (2)
Security Threats (1)
SEO (1)
Software (2)
Spyware (1)
Training (1)
Utilities (1)
Virus (1)
Web Development (2)
Word Press (1)
WP-Syntax (1)
WP-Theme (2)

WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.

Recent Posts

Use unescape(“%26”) to put an ampersand (&) in redirection URLs with javascript…

<script type=”text/javascript”>
var myURL = “” + unescape(“%26”) + “settagview=cloud”;
window.location = myURL;

Concatenating CSV files   March 14th, 2007

Many programs will log data to a CSV (comma separated value) file. These files are usually structured with a standard format. Let’s say you want to import the data into a database or spreadsheet. There is an alternative to importing 2, 5, 10 or 100+ files one at a time. You can concatenate the files into one file. Here is how you do it…

  1. Create a new directory on your hard drive (ie: C:\CSV-Files)
  2. Copy all the files into a new directory.
  3. Open a command window by clicking Start->Run. In the open line type “cmd” and hit return
  4. CD to the directory you created in step one (ie: cd C:\CSV-Files)
  5. Copy all the files to a single file… copy *.csv consolidated.csv
  6. You can now import consolidated.csv into your database or spreadsheet.