Script for Diff b/w 2 CSV files Post: 302686497

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

diff 2 files; output diff's to 3rd file

Hello, I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3. For example: file 1 123 1234 123456 file 2 123 2345 23456 file 3 should have 2345 23456 I have looked at diff, bdiff, cmp, comm, diff3 without any luck!

2. Shell Programming and Scripting

compare 2 coloum of 2 diff files using perl script

Hi, i am new to perl scripting.. i am still learing it.. i am asked to write a perl script which should compare 2 coloums of 2 different files. if those 2 coloumn are same the script should store the both the lines in 2 diff files. these are files, file 1: 21767016 226112 char 19136520...

3. Shell Programming and Scripting

Help with Script: If diff between files is nothing then set a variable

how about a script that compares 2 files using diff (or similar) and if they are then same then set a variable, v1=int else v1=0. thanks

4. Shell Programming and Scripting

calculate diff in csv

I wrote a func to calculcate integers difference in csv. getSegLatency() { latencies=0$1 E2E=0`echo $2 | sed 's/\.000000//g'` integer segLatency=0 set -A arr `echo $latencies | sed 's/\.000000//g' | sed 's/,/ /g'` res=${arr} integer i=1 while ((i < ${#arr })); do ((segLatency=${arr} -...

5. UNIX for Dummies Questions & Answers

Diff script for 2 files.

Hi all, I am stuck up in middle of a process. I have 2 files A and B. Some lines in A are commented with either // or /* */ But basically content (uncommented portion) of both the files are same. Now I want to prove that both the files are same using some script. I can't do a diff as...

6. Shell Programming and Scripting

diff script to copy files to other dir when not exists

I have two directories that are mostly the same: dir1 dir2 Is there an easy way to take the output of diff and copy files from dir1 that do not exist in dir2 - but copy them to the same path (many nested directories). am only trying to copy files in dir1 that do not exist in dir2. ...

7. Shell Programming and Scripting

compare 2 CSV fields from same diff output

Attached is a file called diff.txt It is the output from this command: diff -y --suppress-common-lines --width=5000 1.txt 2.txt > diff.txt I have also attached 1.txt and 2.txt for your convenience. Both 1.txt and 2.txt contain one very long CSV string. File 1.txt is a CSV dump of...

8. Shell Programming and Scripting

Shell script to compare ,diff and remove betwen 2 files

Hi Friends Need your expertise. Command to check the difference and compare 2 files and remove lines . example File1 is master copy and File2 is a slave copy . whenever i change, add or delete a record in File1 it should update the same in slave copy . Can you guide me how can i accomplish...

9. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level. For Example, File 1: A,B,C,D,E,F 1,2,3,4,5,6 File 2: A,C,B,D,E,F 1,2,4,5,5,6 out put file:

10. Shell Programming and Scripting

Diff 3 files, but diff only their 2nd column

Guys i have 3 files, but i want to compare and diff only the 2nd column path=`/home/whois/doms` for i in `cat domain.tx` do whois $i| sed -n '/Registry Registrant ID:/,/Registrant Email:/p' > $path/$i.registrant whois $i| sed -n '/Registry Admin ID:/,/Admin Email:/p' > $path/$i.admin...

LEARN ABOUT DEBIAN

image::exiftool::import

Image::ExifTool::Import(3pm)				User Contributed Perl Documentation			      Image::ExifTool::Import(3pm)

NAME

       Image::ExifTool::Import - Import CSV and JSON database files

SYNOPSIS

	   use Image::ExifTool::Import qw(ReadCSV ReadJSON);

	   $err = ReadCSV($csvFile, \%database);

	   $err = ReadJSON($jsonfile, \%database);

DESCRIPTION

       This module contains routines for importing tag information from CSV (Comma Separated Value) and JSON (JavaScript Object Notation) database
       files.

EXPORTS

       Exports nothing by default, but ReadCSV and ReadJSON may be exported.

METHODS

   ReadCSV / ReadJSON
       Read CSV or JSON file into a database hash.

       Inputs:
	   0) CSV file name.

	   1) Hash reference for database object.

	   2) Optional flag to set '-' values to undef in the database.  (Used for deleting tags.)

	   3) [ReadJSON only] Optional character set for converting Unicode escape sequences in strings.  Defaults to "UTF8".  See the ExifTool
	   Charset option for a list of valid settings.

       Return Value:
	   These functions return an error string, or undef on success and populate the database hash with entries from the CSV or JSON file.
	   Entries are keyed based on the SourceFile column of the CSV or JSON information, and are stored as hash lookups of tag name/value for
	   each SourceFile.

AUTHOR

       Copyright 2003-2011, Phil Harvey (phil at owl.phy.queensu.ca)

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Image::ExifTool(3pm)

perl v5.12.4							    2011-03-12					      Image::ExifTool::Import(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

diff 2 files; output diff's to 3rd file

Discussion started by: blt123

2. Shell Programming and Scripting

compare 2 coloum of 2 diff files using perl script

Discussion started by: vasuki

3. Shell Programming and Scripting

Help with Script: If diff between files is nothing then set a variable

Discussion started by: tuathan

4. Shell Programming and Scripting

calculate diff in csv

Discussion started by: csmklee