Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Script for Diff b/w 2 CSV files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script for Diff b/w 2 CSV files
# 1  
Old 08-14-2012
Script for Diff b/w 2 CSV files
Hello friends,

I have two CSV files.. I am looking to create a script which automatically 'diff' between those 2 csv files each month..Can anyone help me in creating the automatic script which will find the differences between 2 csv files.

Appreciated your help.

Thanks.
# 2  
Old 08-14-2012
Post your script so far.
# 3  
Old 08-15-2012
I haven't created any script as am a newbie to UNIX scripting. Could someone please help me in creating the script..

---------- Post updated 08-15-12 at 09:09 AM ---------- Previous update was 08-14-12 at 04:22 PM ----------

Help me please..!!

---------- Post updated at 11:25 AM ---------- Previous update was at 09:09 AM ----------

Smilie( Smilie(
# 4  
Old 08-15-2012
If your system has cron facility add a line to your crontab:

Code:
30 5 1 * * diff file1 file2 > results

This means run diff on given fies at 5:30 AM on 1st of each month and place output into file results

make sure file1, file2, and results include full path/file names, as a process executed by a cron will have crontab user's home directory as current directory.
This User Gave Thanks to migurus For This Post:
bobby1015
# 5  
Old 08-16-2012
Thanks but unfortunately i don't have cron facility
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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... (10 Replies)
Discussion started by: kenshinhimura
10 Replies

2. 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: (12 Replies)
Discussion started by: karingulanagara
12 Replies

3. 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... (3 Replies)
Discussion started by: ajayram_arya
3 Replies

4. 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... (0 Replies)
Discussion started by: gvolpini
0 Replies

5. 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. ... (5 Replies)
Discussion started by: jvsrvcs
5 Replies

6. 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... (1 Reply)
Discussion started by: bishnu.bhatta
1 Replies

7. 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} -... (2 Replies)
Discussion started by: csmklee
2 Replies

8. 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 (2 Replies)
Discussion started by: tuathan
2 Replies

9. 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 Replies)
Discussion started by: vasuki
3 Replies

10. 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 Replies)
Discussion started by: blt123
2 Replies
Login or Register to Ask a Question