10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I got a requirement where I need to compare two files wrt to each columns and write the corresponding difference in another file along with some identification showing mismatched columns. Pointing out the mismatched columns is my main problem statement. For example we have files like:
File 1 ... (8 Replies)
Discussion started by: piyush pankaj
8 Replies
2. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have txt file below
02.05.2014,10.05.2014,dfs,srtytr,tyhty
05.10.2014,15.10.2014,456ef,t6y5fgtd,xg45t
21.11.2014,28.11.2014,sefser,dfw344,zsdfrw
22.12.2014,30.12.2014,fwe,aerw4,zwq4q
my script will ask two input,
enter start date
05.10.2014
enter end date... (3 Replies)
Discussion started by: stew
3 Replies
4. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
5. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
6. Shell Programming and Scripting
I have two files. One a small one and another one is big. The smaller one look like this:
Filename: 1.tmp
3453 0
326543 1
2321 0
3212 1
The big file looks like this:
Filename 1.res
0.3232 2321
9.2922 123
0.983 3212
8.373 326543
0.9 3453
1.098 3432
I want to extract those lines... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
7. Shell Programming and Scripting
Hello,
I have two files as 1.txt and 2.txt with number as columns.
1.txt
0 53.7988
1 -30.0859
2 20.1632
3 14.2135
4 14.6366
5 -37.6258
.
.
.
31608 -8.57333
31609 -2.58554
31610 -24.2857
2.txt (1 Reply)
Discussion started by: AKD
1 Replies
8. Shell Programming and Scripting
Hi,
I want to compare two columns and find out missing entries e:g
Column 1 Column 2
1 1
2 2
3 13
4
10
19
234
Results woud be 13. I will appreciate very much if anyone help me :). (12 Replies)
Discussion started by: krabu
12 Replies
9. Shell Programming and Scripting
Hi,
I have a table ,containg 2 coloumns and many rows,which is updated everyday.The no.of rows in the table changes everyday.
i have to write the difference between yesterdays tabtle and todays table
to a new file.The row that is new in the todays table need not to be shown.only the change... (2 Replies)
Discussion started by: bab123
2 Replies
10. Shell Programming and Scripting
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (4 Replies)
Discussion started by: ggopal
4 Replies