I want to do a field by word (field) comparison of two files File1.txt and File2.txt.
The files contain a list of | (pipe) separated field.
We compare the same line no. in both the files.
Fields in Line 1 of both file match.
In Line 2 all the fields (lll, mmm, nnn, ooo, ppp) donot not match with all fields (rrr, sss, ttt, uuu, vvv) in line 2 of File 2. Similarly the 5th field of 3rd line in both the files donot match.
Hence Line no. 2 and Line no. 3 should get echoed by bash.
Both files will follow an order.
Is this a homework item? It seems like a strange set of requirements for any non-classroom project.
You haven't shown the output that you want from the input given above, but it seems that you are asking for entire lines from File 1 or entire lines from File 2 to be written to standard output if any field is different. If that is the case, why should we compare fields instead of just comparing lines? Comparing lines should get the same results, is easier to program, and probably run faster.
If you are using awk to compare files; why is it important that bash use the echo command to print the results instead of having awk print the results directly?
Thanks Don for your quick response.
Please find my comments below:
1). Well this is not a homework assignment. It is part of my performance testing project for a investment bank in US. Actually I have got a .csv file as a output of one application run. Now I need to verify the contents of this .csv file against the expected data.
2). Output will look like this:
3). By echo out the output I meant I wanted to print the output in a file/ $ prompt (through print statement in awk). I did not mean of literally using the "echo" command only.
Hope I have answered all your questions. Please revert back to me in case of any further questions.
Thanks for taking time out and helping.
My issue is, I have two files that have file names in it. Now, i need to go through each line of both the files and when the file names are different, i need to rename the file. Below is the example:
filename2,txt... (2 Replies)
I have situation where my file looks like this log.file. ID Start time IP SQL
1256152 05-Aug-15, 11:25:06 MST 10.54.20.33 Select * from TES
1004768 05-Aug-15, 11:25:06 MST 10.54.20.33 Select dummy
323323 05-Aug-15, 12:00:06 MST 10.15.20.77 ... (1 Reply)
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:
What I... (3 Replies)
i have a scenario were i should compare a few fields from each line then increment a variable based on that.
i have 3 conditions to check and increment a variable on every line
condition 1 if ( $3... (4 Replies)
I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from... (4 Replies)
There are two files as below -
/home/rgupta/input/file.txt.arch (source file)
/home/rgupta/output/file.txt (destination file)
Files details are attached for the reference.
File /home/rgupta/input/file.txt.arch picked up by an application xyz. Application xyz does... (2 Replies)
I have two files that I need to compare and print out the line from file2 that has the first 6 fields matching the first 6 fields in file1. Complicating this are the following restrictions
1. file1 is only a few thousand lines at most and file2 is greater than 2 million
2. I need to... (7 Replies)