Compare two tab-delimiter files

Tags

shell scripts

Top Forums Shell Programming and Scripting Compare two tab-delimiter files

Prev Next

09-11-2012

Registered User

14, 0

Join Date: Aug 2012

Last Activity: 11 January 2013, 11:42 AM EST

Posts: 14

Thanks Given: 0

Thanked 0 Times in 0 Posts

Compare two tab-delimiter files

Hi,

I have two files like:

file1

Code:

chr1     40
chr1     50
chr2     10
chr2     60

file2

Code:

chr1     30
chr1     50
chr2     15
chr2     20

and want to get the difference of column 2 when column 1 is the same in both files.

So the output file would be:

Code:

chr1     10
chr1     0
chr2     -5
chr2     40

Could somebody help me? Thanks

Moderator's Comments:

Please use code tags when posting data and code samples!

linseyr

View Public Profile for linseyr

Find all posts by linseyr

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

How can i make a tab delimiter file to a comma delimiter???

2. UNIX for Dummies Questions & Answers

set output delimiter as tab in cut command

I can not make it work, it prints \t rather than introduce tabs. cut -d "," -f 4,8 Samples.csv --output-delimiter="\t" | sort > out Since I am running this command within a shell script, I tried manually inserting tab in this command, still does not work. I am using bash shell Suggestions...

3. Shell Programming and Scripting

Selecting Specific Columns and Insert the delimiter TAB

Hi, I am writing a Perl Script for the below : I have a data file that consists of the header information which is 231 Lines and the footer information as 4 lines. The total number of line including the header and footer 1.2 Million with Pipe Delimited file. For example: Header Information:...

4. Shell Programming and Scripting

Compare Tab Separated Field with AWK to all and print lines of unique fields.

Hi. I have a tab separated file that has a couple nearly identical lines. When doing: sort file | uniq > file.new It passes through the nearly identical lines because, well, they still are unique. a) I want to look only at field x for uniqueness and if the content in field x is the...

5. Shell Programming and Scripting

Compare two columns separated by a tab

witam potrzebuje polecenia porownujacego koumny na podstawie n-ostatnich znakow danej linnijki tj mam 2 koumny AiB zawierajace ciag dowolnych znakow (dlugosci w kazdej linijce mga byc rozne wiec uzycie substra odpada) A B ewewewabc nbgujnnabc...

6. UNIX for Dummies Questions & Answers

Tab delimiter to ""

May be it's simple. But asa new bie I'm having hard time. input : a tab delimited file col c1 c2 c3 a X/X Y/Y D/D b L/L L/L M/M output col c1 c2 c3 "a" "X/X" "Y/Y" "D/D" "b" "L/L" "L/L" "M/M"

7. UNIX for Dummies Questions & Answers

Delimiter: Tab or Space?

Hello, Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another. Thanks, G

8. UNIX for Advanced & Expert Users

how to search delimiter tab in a line and replace it

hi every one plz help me i want to search for a line contains tabspace This is a line The should be changed see the above line is seperated with tab space i want to replace that tab space in to # as This is a line#The should be changed i have tried with...

9. Shell Programming and Scripting

append data in a file by using tab delimiter

Hi, I need to append the data in to a file by using tab delimiter. eg: echo "Data1" >> filename.txt echo "\t" >> filename.txt (its not working) echo "Data2" >> filename.txt. the result sould be like this. Data1 Data2

10. Shell Programming and Scripting

Cutting a tab delimiter file

I have a 30 column tab delimited record file. I need to extract the first 10column. The following command to cut was not working cut -f 1-10 -d "\t" filename. Could any one keep on this . Thanks in Advance

Shell Programming and Scripting