I am using "grep -vF -f *.txt" command to compare,
but here is some issue, comparison is not working correctly...i want to compare file1 with file2, only column 2/3 in file2 should compare, if there is any difference should get output in file3.
---------- Post updated at 01:43 PM ---------- Previous update was at 01:37 PM ----------
see example i am expecting...
Aggr_New_06_19_2013_1944.txt has below records
Right now i am getting output:
But Actual Output expecting should be like below...
Script should compare only 2/3 columns in file2...please help on it.
Last edited by Scott; 07-03-2013 at 05:24 PM..
Reason: Code tags
I give up. After two weeks of wasting our time, you now completely change the requirements used to determine the output you want. And you still haven't answered the basic question of how we are supposed to know which of the two files in a directory is the "1st" file and which is the "2nd" file.
If you want help on this new problem, start a new thread. In that thread:
Give a complete description of what your input files look like (expected sizes, field separators, sample contents, filename format).
Give a complete description of the processing that needs to be performed to produce the results you want.
Show sample output that should be produced when your input files are processed as you described.
1.Give a complete description of what your input files look like (expected sizes, field separators, sample contents, filename format).
One of our unix script will get 2 files from windows server and place in unix folder1(Everyday it will clean the folder and place only 2 files). these 2 files names change daily as file names contains date timestamp(File names like 'Jun_Agg_06_19_2013_1944.txt'),file size depends on data we get daily, it varies from 5MB -60MB filesize. so now we need to compare these two files and get output in 3rd file.
Input files contains only 5 columns with '|' delimeter, column1, 4,5 can be same, but we used to get difference in input files in column2 and 3, based on column 2 and column 3, file1 should compare with file2 and get result in file3.
2.Give a complete description of the processing that needs to be performed to produce the results you want.
Explained complete process above
3.Show sample output that should be produced when your input files are processed as you described.
see example below..
File1:
File2:
Right now i am getting output:
But Actual Output should be like below...
Files should compare based on 2nd and 3rd columns and get output in to file3.
Moderator's Comments:
Please use CODE tags when showing sample input and output files as well as when showing code samples.
Last edited by Don Cragun; 07-03-2013 at 06:11 PM..
Reason: CODE tags
Thanks mjf, its working perfectly for comparison, can do manually.
But my requirement is to automate that file comparison, how can we automate this by using above script as i can't hard coded the file names as daily file names will change with time stamp?? please help.
Hi all,
I have a log file say Test.log that gets updated continuously and it has data in pipe separated format. A sample log file would look like:
<date1>|<data1>|<url1>|<result1>
<date2>|<data2>|<url2>|<result2>
<date3>|<data3>|<url3>|<result3>
<date4>|<data4>|<url4>|<result4>
What I... (3 Replies)
Hello,
I need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line... An example of entries in the file would be:
SRVXPAPI001 ERRO JUN24 07:28:34 1775
REASON= 0000, PROCID= #E506 #1065: TPCIPPR, INDEX= 003F
... (8 Replies)
Hi everybody,
First I apologize if my question seems demasiad you silly, but it really took 4 days struggling with this, I looked at books, forums ... And Also ask help to a friend that is software developer and he told me that it is a bad idea do it by perl... but this is my problem.
I moved to... (8 Replies)
Hi,
i have file which contains data as below(Only sample shown, it may contain more data similar to the one shown here)
i need to read this file line by line and generate an output file like the one below
i.e based on N value the number of MSISDNs will vary, if N=1 then the following... (14 Replies)
So, I want to read line-by-line a text file with unknown number of files....
So:
a=1
b=1
while ; do
b=`sed -n '$ap' test`
a=`expr $a + 1`
$here do something with b etc
done
the problem is that sed does not seem to recognise the $a, even when trying
sed -n ' $a p'
So, I cannot read... (3 Replies)
Hi,
I am trying to find an alternative way to do tkdiff. In tkdiff the gui compares each line and highlights only the differences.
for eg:
John works at McDonalds s(test)
He was playing guitar tywejk
John works in McDonalds 9908
He was playing guitar
I am... (1 Reply)
File 1
<html>ta da....unique file name I want to give file=>343...</html>
<html>da ta 234 </html>
<html>pa da 542 </html>
and so on...
File 2
343
234
542
and so on, each line in File 1 one also corresponds with each line in File 2
I have tried several grep, sed, while .. read, do,... (4 Replies)
i have two files and i want to compare these two
it shoud print those lines which are not in 2nd file
a.txt
1236,AB,0
2345,CD,1
5679,EF,1
9123,AA,1
9223,AA,0
b.txt
1234,AB,0
2345,CD,1
5678,EF,1
9123,AA,0
o/p
1236,AB,0
5679,EF,1
9123,AA,1
9223,AA,0 (6 Replies)