Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Basic MySQL. XOR?



Dwight E Chadbourne wrote:
> Two people are handing me CSV files and I don't care about what they
> agree on.

If you want to see differences at the record (line) level, try:

% diff --old-line-format=%L --new-line-format=%L
--unchanged-line-format="" data1.csv data2.csv > diff.csv

diff.csv should end up with none of the lines that are identical in the
two source files, and only contain the lines that differ.

You can the load diff.csv into MySQL.

  -Tom

-- 
Tom Metro
Venture Logic, Newton, MA, USA
"Enterprise solutions through open source."
Professional Profile: http://tmetro.venturelogic.com/

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org