Match file and find count


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Match file and find count
# 1  
Old 03-29-2018
Match file and find count

Hi All,

I have transaction in one file.I want to match that to another file and find the number of time the transaction is available on the other file.I need to take each record from TRANSFILE and match that with SPEND FILE and find the number of counts of the transaction

TRANSFILE:

Code:
1000189376
100500004296
1013558744
1013558748
1013558861
1019100045
1019135000
1025088101


SPEND FILE:
Code:
1450001254;5.79
2114014282;3.18
1013558744;1.89
1013558744;3.29
2114021154;0.60
2114021220;0.73
2114026059;2.69
2114026118;2.29
2114027918;1.69
1019135000;1.06

Output should be like


Code:
1000189376 ----->0
100500004296 ---->0
1013558744 ----->2
1013558748 ----->0
1013558861----->0
1019100045 ----->0
1019135000 ----->1
1025088101----->0


Last edited by arunkumar_mca; 03-29-2018 at 03:54 PM.. Reason: Added text
# 2  
Old 03-29-2018
Try:
Code:
awk 'NR==FNR{C[$1]++; next} {printf "%-13s----->%s\n", $1, C[$1]+0}' FS=\; sendfile FS=" " transfile

This User Gave Thanks to Scrutinizer For This Post:
# 3  
Old 03-29-2018
Just a little warning

Just to bring your attention about the fact that Scrutinizer's code assumes that multiples occurrences of a transaction in "spend file/sendfile" must be sequential ... (since the display of computing is dynamic rather than post-processed in an END{...} block )
# 4  
Old 03-30-2018
Why must they be sequential @ctsgnb? An array is used to count the occurrence in the spend file and in a way "post processed" while reading the transfile... No matter how the records in the spend file are arranged, the outcome is the same..
# 5  
Old 03-31-2018
Quote:
Originally Posted by Scrutinizer
An array is used to count the occurrence in the spend file and in a way "post processed" while reading the transfile...
You are right, but another warning is in order: because the processing is done in memory the script has - depending on the sizes of the files involved - the potential to exhaust the systems memory if the files are very big and/or the RAM is small.

I hope this helps.

bakunin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to find the count of IP addresses that belong to different subnets and display the count?

Hi, I have a file with a list of bunch of IP addresses from different VLAN's . I am trying to find the list the number of each vlan occurence in the output Here is how my file looks like 1.1.1.1 1.1.1.2 1.1.1.3 1.1.2.1 1.1.2.2 1.1.3.1 1.1.3.2 1.1.3.3 1.1.3.4 So what I am trying... (2 Replies)
Discussion started by: new2prog
2 Replies

2. UNIX for Beginners Questions & Answers

How to count lines of CSV file where 2 fields match variables?

I'm trying to use awk to count the occurrences of two matching fields of a CSV file. For instance, for data that looks like this... Joe,Blue,Yes,No,High Mike,Blue,Yes,Yes,Low Joe,Red,No,No,Low Joe,Red,Yes,Yes,Low I've been trying to use code like this... countvar=`awk ' $2~/$color/... (4 Replies)
Discussion started by: nmoore2843
4 Replies

3. UNIX for Dummies Questions & Answers

How to find count total number of pattern in a file ?

How to find count total number of pattern in a file … File contains : a.txt ------------- aaa bbb nnn ccc aaa bbb aaa ddd aaa aaa aaa aaa grep -c aaa a.txt Op: 4 ( But my requirement is should count the total no of patterns as 7 ) (4 Replies)
Discussion started by: Jitten
4 Replies

4. Shell Programming and Scripting

Match look up file and find result

Hi I ahve a lookup file wiht seven words CD HT CAD HT T1D T2D BDanother file contain data like this CHRM1 P11229 Pirenzepine DAP000492 Peptic ulcer disease Approved T2D CHRM1 P11229 Glycopyrrolate DAP001116 Anesthetic Approved T2D CHRM1 P11229 ... (7 Replies)
Discussion started by: manigrover
7 Replies

5. Shell Programming and Scripting

File count for symlink using find command

Hi Guys, The script which I am using works really good for finding the file count for files that are not symlink. I know I can use find command like: find . -type l | wc -l This way I can get filecount of the symlink but is there a one liner to use -type l and -type f option ? That is... (4 Replies)
Discussion started by: dixits
4 Replies

6. Shell Programming and Scripting

Count the delimeter from a file and delete the row if delimeter count doesnt match.

I have a file containing about 5 million rows, in the file there are some records which has extra delimiter at random position. (we dont know the positions), now we have to Count the delimeter from each row and if the count of delimeter is not matching then I want to delete those rows from the... (5 Replies)
Discussion started by: Akumar1
5 Replies

7. Shell Programming and Scripting

How to find lines that match exact input and count?

I am writing a package manager in BASH and I would like a small snippet of code that finds lines that match exact input and count them. For example, my file contains: xyz xyz-lib2.0+ xyz-lib2.0 xyz-lib1.5 and "grep -c xyz" returns 4. The current function is: # $1 is the package name.... (3 Replies)
Discussion started by: cooprocks123e
3 Replies

8. Shell Programming and Scripting

How to find first match and last match in a file

Hi All, I have a below file: ================== 02:53 pravin-root 02:53 pravin-root 03:05 pravin-root 02:55 pravin1-root 02:59 pravin1-root ================== How do I find the first and last value of column 1. For example, how do I find 02:53 is the first time stamp and 03:05 is... (3 Replies)
Discussion started by: praving5
3 Replies

9. Shell Programming and Scripting

How to find a count of a word within a file

Hello, I'm looking for a wait to count the number of occurrences of a certain string of characters within a file. The file that I trying to parce has segments within the file that have a header and footer to each segment and I'm trying to do a count of the header string and compare it to a count... (9 Replies)
Discussion started by: bd_joy
9 Replies

10. Linux

To find multiple strings count in a file

I need to find the line count of multiple strings in a particular file. The strings are as follows: bmgcc bmgccftp bsmsftp bulkftp cctuneftp crbtftp crmpos cso gujhr I am doing manual grep for each of the string to find the line count. The command i am using right now is: grep mark... (3 Replies)
Discussion started by: salaathi
3 Replies
Login or Register to Ask a Question

Featured Tech Videos