Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Compare one field

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare one field
# 1  
Old 02-18-2010
Compare one field
Hello to every one:

i have and archive like this:

Code:
5552952099|5552952099|VAHC600312UY9|VARGAS HERNANDEZ MA DEL CARMEN|METRO|LOMAS|CC|20||||900661026|1|METRO
5552952115|5552952949|AABF680818FT7|ABASOLO BONILLA FERDINAND|METRO|LOMAS|CC|20||||900671255|1|METRO
5552952130|5552952949|AABF680818FT7|ABASOLO BONILLA FERDINAND|METRO|LOMAS|CC|20||||900671255|1|METRO

and i need to make a script first tha i make a sort form field 2 and match field 2 in the same file and have two files from exit one that match and another thas not match anyone can help me?

Thanks to all
Last edited by Scott; 02-18-2010 at 02:23 PM.. Reason: Please use code tags
# 2  
Old 02-18-2010
What have you tried?
# 3  
Old 02-18-2010
i tried the sort but and uniq -d but i donīt know how i tried i field two not in field one
# 4  
Old 02-18-2010
Are you matching second field with first field? Then try awk
# 5  
Old 02-18-2010
No i want to sort second field and after mach the second field thks
# 6  
Old 02-18-2010
This will create two files and then you can sort it.
Code:
awk -F"|" ' { if( $1 == $2 ) { print > "Match" } else { print > "NoMatch" } } ' file

# 7  
Old 02-19-2010
Thank You thatīs that i want but i have another cuestion, whocan i do in the same field ? thank you very muchSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in splitting Sub Fields and compare with other field

Hi All, We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1" position in the 3rd field and from 4th field need to extract the information from the same position. ... (4 Replies)
Discussion started by: rramkrishnas
4 Replies

2. Shell Programming and Scripting

Plz Help. Compare 2 files field by field and get the output in another file.

Hi Freinds, I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output. Source.txt 1|HYD|NAG|TRA|34.5|1234 2|CHE|ESW|DES|36.5|134 3|BAN|MEH|TRA|33.5|234... (5 Replies)
Discussion started by: i150371485
5 Replies

3. Shell Programming and Scripting

Compare two files Field by field and output the result in another file

Hi Friends, Need Help. I have file1.txt as File1.txt |123|A|7267|Hyder|Cross|Sell|7801 |995|A|7051|2008|Lunar|New|Year|Promotion|7801 |996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801 |997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801 File2.txt... (7 Replies)
Discussion started by: i150371485
7 Replies

4. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

5. Programming

how to compare value of mysql field

#include <stdio.h> #include <fcntl.h> #include <signal.h> #include <unistd.h> #include <mysql.h> #include <string.h> #include <stdlib.h> #include <sys/time.h> #include <mysql.h> int main(int argc, char **argv) { MYSQL *conn; MYSQL_RES *result; MYSQL_ROW row; ... (0 Replies)
Discussion started by: slackman
0 Replies

6. Shell Programming and Scripting

compare two fields and get a third field

Hello, I'm trying to get a value based on a comparison of two fields, this is: file1 687.45 687.18 687.322 687.405 686.865 file 2 685 6.43 686 6.43 687 6.42 688 6.42 (3 Replies)
Discussion started by: Gery
3 Replies

7. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

8. Shell Programming and Scripting

AWK to compare two files for each field value

I have "n" files in directory A and "n" files in directory B. The files are expected to be the same with same data. Each file has 14 columns and "x" rows. Of the 14 column, 2 columns are to be considered as key identifiers. Based on this unique combination, I need to compare each field value... (2 Replies)
Discussion started by: Sangtha
2 Replies

9. Shell Programming and Scripting

compare second field

Hi, I have two files, mentioning below 1st file: 919030055000,1 919030055000,3 919030055000,7 919030155000,1 919030155000,3 919031055000,1 919031055000,8 919031155000,1 919031155000,8 919036055000,3 919036055000,7 919036155000,3 919036155000,7 919040055000,1 919040055005,7... (9 Replies)
Discussion started by: kaprus
9 Replies

10. Shell Programming and Scripting

How to compare a field value of a same column?

I have a file which has entries like as below, 10:29:07.32 GOOD 122 10:29:07.35 GOOD 124 10:29:09.97 BAD 122 10:29:09.97 BAD 124 10:29:18.66 ... (6 Replies)
Discussion started by: gobinath
6 Replies
Login or Register to Ask a Question