compare csv files

Discuss RoboTask here
Post Reply
rice1973
Posts: 86
Joined: Mon Jan 04, 2010 2:38 am
Location: Netherlands
Contact:

compare csv files

Post by rice1973 »

Hi,Is it possible to compare 2 csv files and save the different lines?Example of CSV file; id_product,reference,model_name,ean13,quantity,price,reducti on_price,description_short,meta_description,meta_title,name, id_manufacturer,size,season,color "3600","154.30.007","B4322971","010035990109","1","64.95","6 4.95","Een trendy sportieve sneaker van het merk Bullboxer Heren. De zijkant is voorzien van een opvallend rood embleem. De sneaker is vervaardigd van gevet leer en voorzien van lichte stiksels die samen een fraai patroon vormen.","Bullboxer heren blauwe lage sportieve heren veterschoen. Herenschoenen van het schoenenmerk Bullboxer heren bestel je nu zeer gemakkelijk online via .nl. De grootste online schoenen winkel en laarzen winkel.","Bullboxer heren blauwe lage sportieve heren veterschoen B4322971 - Herenschoenen - Online Bestellen En Kopen Bij .","Bullboxer heren","72","3","44","51"
Oleg
Site Admin
Posts: 3202
Joined: Thu Jan 01, 1970 1:00 am
Contact:

compare csv files

Post by Oleg »

I think that it's better to compare CSV files as simple text files.
Use such command line:

fc file1.csv file2.csv > differences.txt

or use the command interpreter:

cmd /c fc file1.csv file2.csv > differences.txt

Of cource you have to specify full path of files if it's necessary.
rice1973
Posts: 86
Joined: Mon Jan 04, 2010 2:38 am
Location: Netherlands
Contact:

compare csv files

Post by rice1973 »

Hi,I tried this, but it "breaks" up the results after 254 caracters per line in the csv. I need up to 1000 caracters per line.It should display the complete diferent CSV lines and not a peace of it.Any ideas?
Last edited by rice1973 on Thu May 20, 2010 5:49 am, edited 1 time in total.
rice1973
Posts: 86
Joined: Mon Jan 04, 2010 2:38 am
Location: Netherlands
Contact:

compare csv files

Post by rice1973 »

Hi,Any solution for this?
Post Reply