Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparing 2 csv files and matching content
Top Forums Shell Programming and Scripting Comparing 2 csv files and matching content Post 302347782 by ghl10000 on Wednesday 26th of August 2009 04:58:08 PM
Old 08-26-2009
Thanks vgersh99 !
Actually I was just asking myself if there's an alternative, when I found that "nawk", which I didn't know before.
Yes, it was on the machine :-)
And it worked perfectly.
Was about to close this thread when I found your kind hint, which crossed with my own investigations.

So, thanks to both of you, Klashxx and vgersh99. You made my day.

I think we should compile kind of "Cookbook For Solving the Most Common Issues Using Shell Tools".

I think the problem I needed a solution for is a very common one: matching various "check lists" and adding one (or more) items to each line of one file if there's a match on the other.

And those "crude" shell tools work so damned fast...

Again thanks so much for helping me

---------- Post updated at 10:12 PM ---------- Previous update was at 10:09 PM ----------

Hi once more,
how would your solution have to be modified in case the "reference column" of csvfile #1 is not the first column but e.g. the third column ?

I tried with

Code:
awk 'NR==FNR{a[$1]=$2;next}{$0=$0","a[$3]}1' FS=',' csv-file2 csv-file1

but it found only 1 hit and other lines just ended on a colon.

---------- Post updated at 10:58 PM ---------- Previous update was at 10:13 PM ----------

Hi once more,
how would your solution have to be modified in case the "reference column" of csvfile #1 is not the first column but e.g. the third column ?

I tried with

Code:
awk 'NR==FNR{a[$1]=$2;next}{$0=$0","a[$3]}1' FS=',' csv-file2 csv-file1

but it found only 1 hit and other lines just ended on a colon.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comparing files content

hi i have a set of files , i need to compare one file content with other file content, i am using cmp -s abc.1 def.2 , but it is not giving theproper o/p even if the content is different.Please help thanks Satya (1 Reply)
Discussion started by: Satyak
1 Replies

2. Shell Programming and Scripting

AWK - Comparing/Matching/Counting with 2 files

I have 2 files that I want to do some comparing on. First, I want to find the unique list of devices in file1 and then put them to a new file, file2. I was able to do this without any problem with the following statement: cat file1 | awk '{print $2}' | awk '!x++' > file2Here is what I can't... (2 Replies)
Discussion started by: jontjioe
2 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 2 files and creating third file with uncommon content

I want to compare 2 files and create third file with uncommon content. e.g. file1 ajay suhas tom nisha vijay mahish file2 ajay suhas tom nisha expected output file content vijay mahish Is it possible in single command ? Thanks, Ajay (6 Replies)
Discussion started by: ajaypatil_am
6 Replies

5. Shell Programming and Scripting

comparing two files for matching fields

I am newbie to unix and would please like some help to solve the task below I have two files, file_a.text and file_b.text that I want to evaluate. file_a.text 1698.74 1711.88 6576.25 899.41 3205.63 4187.98 697.35 1551.83 ... (3 Replies)
Discussion started by: gameli
3 Replies

6. Shell Programming and Scripting

Comparing 2 difference csv files

Hello, I have about 10 csv files which range from csv1 - csv10. Each csv file has same type/set of tabs and we have around 5-6 tabs for each of the csv file which have slightly different content(data). A sample of CSV1 is shown below: Joins: Data related to Joins, it can be any number of... (2 Replies)
Discussion started by: bobby1015
2 Replies

7. 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

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. Shell Programming and Scripting

Comparing two files by two matching fields

Long time listener first time poster. Hope someone can advise. I have two files, 1000+ lines in each, two fields in each file. After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those... (6 Replies)
Discussion started by: bstaff
6 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

LEARN ABOUT DEBIAN

csv2mipe

CSV2MIPE(1)						User Contributed Perl Documentation					       CSV2MIPE(1)

NAME

       csv2mipe.pl - Generates MIPE file based on 3 tab-delimited files
	 based on MIPE version v1.1
	 arguments: * tab-delimited file with PCR-level data
		    * tab-delimited file with SNP-level data
		    * tab-delimited file with assay-level data

	 Columns in file with PCR-level data:
	   pcr_id
	   pcr_modified (might be multiple, divided by semi-colon ";")
	   pcr_project (might be multiple, divided by semi-colon ";")
	   pcr_researcher (might be multiple, divided by semi-colon ";")
	   pcr_species
	   source_type
	   source_id
	   design_seq
	   primer1_oligo
	   primer1_seq
	   primer1_tm
	   primer2_oligo
	   primer2_seq
	   primer2_tm
	   design_remark (might be multiple, divided by semi-colon ";")
	   use_seq
	   use_revcomp
	   use_remark (might be multiple, divided by semi-colon ";")
	   pcr_remark (might be multiple, divided by semi-colon ";")

	 Columns in file with SNP-level data:
	   pcr_id
	   snp_id
	   snp_pos
	   snp_amb
	   snp_remark (might be multiple, divided by semi-colon ";")

	 Columns in file with assay-level data:
	   pcr_id
	   snp_id
	   assay_id
	   assay_type
	   assay_enzyme
	   assay_oligo
	   assay_specific
	   assay_tail
	   assay_strand
	   assay_remark (might be multiple, divided by semi-colon ";")

SYNOPSIS

       csv2mipe.pl <pcr_file.csv> <snp_file.csv> <assay_file.csv>

ADDITIONAL INFO

       See http://mipe.sourceforge.net

AUTHOR

       Jan Aerts (jan.aerts@bbsrc.ac.uk)

perl v5.14.2							    2005-07-20							       CSV2MIPE(1)
All times are GMT -4. The time now is 01:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy