Long time listener first time poster. Hope someone can advise.
I have two files, 1000+ lines in each, two fields in each file.
After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those into file3?
Field 1 will always be unique within the files, but not field 2, there could be numerous entries of the same text.
So where field 1 and field 2 on a line in file 1, both only exist on the same line in file 2, output to file 3.
Thanks in advance.
File 1
Code:
abcdefgh name1
bcdefgha name2
nmrsthji namei
nmdherya wood
kasjfhsw moon
pqoweiru sun
wershgsy other
iundhstw tree
gfhskwyt mine
alskalak hoover
File 2
Code:
abcdefgh name1
bcdefgha name5
hjgdrnja namej
nmdherya notwood
kasjfhsw moon
wershgsy other
pqoweiru sun
gfhskwyt mine
alskalak hoover
--- Post updated at 02:25 PM ---
Confusing myself.
I dont mean field 1 and field 2 on line 3 in file 1, have to be on line 3 in file 2.
But field 1 and 2 on line 3, must match in file 2, on any line, then output to file 3.
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 01-24-2019 at 10:28 AM..
Reason: Added CODE tags.
Hi Experts,
I need your timely help. I have a problem with merging two files. Here my situation :
Here I have to compare first three fields from FILE1 with FILE2. If they are equal, I have to append the remaining values from FILE2 with FILE1 to create the output.
FILE1:
Class ... (3 Replies)
I have two files with ids and email addresses. File 2 cotains a subset of the records in file 1. The key field is the first field containing the id.
file 1:
123|myadr@abc.com
456|myadr2@abc.com
789|myadr3@abc.com
file 2:
456|adr456@xyz.com
Where the record appears in the second... (3 Replies)
Hi,
i want to compare two files by one field say $3 in file1 needs to compare with $2 in file2.
sample file1 - reqd_charge_code
2263881188,24570896,439
2263881964,24339077,439
2263883220,22619162,228
2263884224,24631840,442
2263884246,22612161,442
sample file2 - rg_j
... (2 Replies)
Hi all,
I searched the forum and tried to learn from the similar posts. However, I am new and I need to get help on this. I hope an expert kindly help me to sort this out.
I need to compare field 1 and 2 of the first file with the same fields of the second file and if both fields matches... (9 Replies)
I've 2 files. Need to compare File1.Field1,File1.Field2 with File2.Field1,File2.Field2. If matches then create a new file.
File1
10 A|ADB|967143.24|1006101.5
3E HK|DHB|24294.76|242513.89
ABN ACU|ADB|22104.69|51647.14
ABN BU|DBA|39137.14|109128.38
ABN|ADB|64466.89|167936.55
ABOC... (2 Replies)
Hi,
I have two files formatted as following:
File 1: (user_num_ID , realID) (the NR here is 41671)
1 cust_034_60
2 cust_80_91
3 cust_406_4
..
..
File 2: (realID , clusterNumber) (total NR here is 1000)
cust_034_60 2
cust_406_4 3
..
.. (11 Replies)
I am newbie to unix and would please like some help to solve the task below
I have two files, file_a.text and file_b.text that I want to evaluate.
file_a.text
1698.74
1711.88
6576.25
899.41
3205.63
4187.98
697.35
1551.83 ... (3 Replies)
I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5).
Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2 are... (1 Reply)
Dear All,
I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5).
Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2... (6 Replies)
Hi all,
I have two files as below. I need to compare field 2 of file 1 against field 1 of file 2 and field 5 of file 1 against filed 2 of file 2. If both matches , then create a result file 1 with first file data and if not matches , then create file with first fie data. Please help me in... (1 Reply)
Discussion started by: sivarajb
1 Replies
LEARN ABOUT DEBIAN
cssort
CSSORT(1p) User Contributed Perl Documentation CSSORT(1p)NAME
cssort -- Czech sort
FORMAT
cssort [ "-c"list | "-f"list ["-d"regexp]] [files ...]
SYNOPSIS
cssort -c10-15,50-,25-45 < file
cssort -f3,5-6 < file
cssort -f3,5-6 -s: < file
DESCRIPTION
Cssort is a utility that sorts input lines according to rules used in the Czech language. You can run it without any options, then it just
uses whole lines for sorting. With the options, it's possible to specify parts of the lines to be used for comparison.
list
A comma-separated list of integer field numbers or field ranges. The are indexed from 1 and if a range is open (eg. "5-"), it means all
remaining fields from the starting number.
-c Stands for columns and the list that follows specifies byte ranges on the line. You will probably use this option to sort data with
fixed width fields.
-f Fields that will be used for sort.
-d Delimiter that separates fields in the -f option. It is a Perl regular expression, the default is "[ ]+", which means any number of
spaces or tabs in a row.
The program assumes ISO-8859-2 encoding. Some way to specify another input encoding will come in the next versions. If you need to sort
files with different encodings, you might want to check the cstocs conversion utility.
SEE ALSO Cz::Sort(3), cstocs(1).
AUTHOR
Jan Pazdziora, adelton@fi.muni.cz.
perl v5.10.1 2010-01-16 CSSORT(1p)
01-24-2019
