Sponsored Content
Top Forums Shell Programming and Scripting Comparing 2 difference csv files Post 302691461 by bobby1015 on Friday 24th of August 2012 02:51:04 PM
Old 08-24-2012
No..I need the output to be displayed in an excel sheet.


The tabs which we have in the csv files are list of tables, columns and the joins which are relevant to those tables. If we have any changes corresponding to the 2 csv files, it should pop up in the excel sheet..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Last field problem while comparing two csv files

Hi All, I've two .csv files as below file1.csv abc, tdf, 223, tpx jgsd, tex, 342, rpy a, jdjdsd, 423, djfkld Where as file2.csv is the new version of file1.csv with some added fields in the end of each line and some additional lines. lfj, eru, 98, jkldj, 39, jdkj9 abc, tdf, 223, tpx,... (3 Replies)
Discussion started by: ganapati
3 Replies

2. Shell Programming and Scripting

Comparing Strings in 2 .csv/txt files?

EDIT: My problems have been solved thanks to the help of bartus11 and pravin27 This code is just to help me learn. It serves no purpose other than that. Here's a sample csv that I'm working with - #listofpeeps.csv Jackie Chan,1954,M Chuck Norris,1930,M Bruce Lee,1940,M This code is... (13 Replies)
Discussion started by: chickeneaterguy
13 Replies

3. Shell Programming and Scripting

comparing csv files

Hi! I'm just new to shell scripting n simple tasks looks so tough in initial stage. i need to write a script which will read a property file, property file will be containing count of the csv files, and in a folder(same folder) there will be respective csv files. like Property file data1=100... (3 Replies)
Discussion started by: sukhdip
3 Replies

4. Shell Programming and Scripting

Comparing text in 2 files and output difference in another file.

I have 2 files of almost same text apart from 2,3 ending lines. Now I want to get that difference in another file. e.g file1.txt is Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_livecd-lv_root 18G 2.4G 15G 14% / tmpfs 504M ... (12 Replies)
Discussion started by: kashif.live
12 Replies

5. Shell Programming and Scripting

Comparing 2 CSV files and sending the difference to a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 ... (1 Reply)
Discussion started by: Naresh101
1 Replies

6. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

7. Shell Programming and Scripting

Comparing two files with numbers and taking difference in third file

Hi All, I have two files in the following format, with numbers being defined under columns(described by a set of headers) and rows(again defined by a set of identifiers) 2013 2013 Make200 Make201 Merc BMW Jpur Del ... (9 Replies)
Discussion started by: dev.devil.1983
9 Replies

8. Shell Programming and Scripting

Comparing two CSV files

I have two csv files and im trying to compare them. e.g. SAMPLE DATA: file one: ZipCode Name 20878 Washington 10023 Missouri 20304 Maryland file two: ID Name City ZipCode 11654 ... (11 Replies)
Discussion started by: dan139
11 Replies

9. UNIX for Beginners Questions & Answers

awk assistance - Comparing 2 csv files

Hello all, I have searched high and low for a solution to this, many have come really close but not quite what I'm after. I have 2 files. One contains GUID's, for example: 8121E002-96FE-4C9C-BC5A-6AFF20DACECD 84468F30-F3B7-418B-81F0-0908E80792BF A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies

10. UNIX for Beginners Questions & Answers

Comparing two files and list the difference with common first line content of both files

I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ? Source File ************* # file: /local/test_1 # owner: own #... (4 Replies)
Discussion started by: sarathy_a35
4 Replies
AMC-REGROUPE(1) 					       Auto Multiple Choice						   AMC-REGROUPE(1)

NAME
AMC-regroupe - merge JPEG annotated AMC multiple choice answer sheets to get a PDF file per student. SYNOPSIS
auto-multiple-choice regroupe --projet project-dir --sujet subject.pdf --modele file-name-model --fich-noms students-list.csv [--noms-encodage encoding] [--compose] DESCRIPTION
The command AMC-regroupe.pl merges annotated AMC multiple choice answer sheets (there is one per page) to get a single PDF file per student. --data data-dir gives the directory where data files are (see for example AMC-meptex(1)). --projet project-dir Gives the project directory. --sujet subject.pdf gives the subject file (as prepared by AMC-prepare(1)). This helps in getting the page size for the subject to make annotated PDF fit this size. --fich-noms students-list.csv sets the students list file name. --noms-encodage encoding selects an encoding for file students-list.csv (default is utf-8). --modele file-name-model sets a file name model for annotated PDFs. In this model, some sequences will be substituted: (N) is replaced by the student's name. (ID) is replaced by the student number. (COL) is replaced by the value of column COL in the students list for the curent student. The default value is '(N)-(ID).pdf'. --compose When using this option, pages for which there is no scan will be replaced by the corresponding page from the corrected answer sheet. This option is for example useful when using the separate answer sheet layout: in this case, the annotated answer sheet will not be readable without the pages with the questions. When using the --compose option, one must also use the --tex-src (and optionnaly --with, --filter and --filtered-source) option. --tex-src mcq-source-file gives the source file for the subject. --with latex-engine gives the LaTeX engine (command) to be used to process the (optionaly filtered) source file. latex-engine can be pdflatex or xelatex for exemple. --filter filter sets the filter name to transform the MCQ source file into a LaTeX file (see AMC-prepare(1)). --filtered-source mcq-latex-file gives the LaTeX file to make from the source file using specified filter (see AMC-prepare(1)). --debug file.log gives a file to fill with debugging information. AUTHORS
Alexis Bienvenue <paamc@passoire.fr> Main author Jean Berard Translation from French Georges Khaznadar Translation from French COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue This document can be used according to the terms of the GNU General Public License, version 2 or later. Auto Multiple Choice 1.1.1 06/19/2012 AMC-REGROUPE(1)
All times are GMT -4. The time now is 08:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy