Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Counting number of times content in columns occurs in other files
Top Forums Shell Programming and Scripting Counting number of times content in columns occurs in other files Post 302981493 by RavinderSingh13 on Tuesday 13th of September 2016 05:55:26 PM
Old 09-13-2016
Quote:
Originally Posted by RudiC
Try also
Code:
awk 'NR==FNR {T[$1,$2]; next} ($1,$2) in T {T[$1,$2]++} END {for (t in T) print t, T[t]}' SUBSEP=" " file[1-4]
33.43 -112.00 2
35.14 -111.67 3
32.30 -86.41 3
34.65 -112.43 3
30.68 -88.24 3
32.13 -110.96 2

Hello RudiC,

Thank you for nice code. I think OP has requested if there are at least one occurrences of fields 1st and 2nd from source file/Input_file(file.txt).
So if have to put a condition at last to check that else it will print those lines too which are coming only in very first/source file too.
Code:
awk 'NR==FNR {T[$1,$2]; next} ($1,$2) in T {T[$1,$2]++} END {for (t in T){if(T[t]>1){print t, T[t]}}}' SUBSEP=" "  file.txt  198108-new.txt  198208-new.txt  201608-new.txt

Output will be as follows.
Code:
35.14 -111.67 3
32.30 -86.41 3
30.68 -88.24 3
34.65 -112.43 3
33.43 -112.00 2
32.13 -110.96 2

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Counting Number of times a File is accessed

Hi, I need to count the number of times a script is accessed from within the script. Is it possible ? Example: I have a script called lo.sh and i execute the script for the first time, then the counter variable declared inside the lo.sh should increment by 1. For every execution the... (1 Reply)
Discussion started by: pathanjalireddy
1 Replies

2. UNIX for Dummies Questions & Answers

Counting number of files in a directory

Some simple questions from a simple man. If i wanted to count the number of files contained within a directory, say /tmp would ls -l /tmp ¦ wc -l suffice and will it be accurate? second one: How would i check the number of files with a certain string in the filename, in the same directory. ... (2 Replies)
Discussion started by: iamalex
2 Replies

3. Shell Programming and Scripting

TO find the word which occurs maximum number of times

Hi Folks !!!!!!!!!!!!!!!!!!! My Requirement is............. i have a input file: 501,501.chan 502,502.anand 503,503.biji 504,504.raja 505,505.chan 506,506.anand 507,507.chan and my o/p should be chan->3 i.e. the word which occurs maximum number of times in a file should be... (5 Replies)
Discussion started by: aajan
5 Replies

4. Shell Programming and Scripting

need help with counting of files then pass number to variable

hi all, i'm trying to pass a count of files to a variable thru these set of codes: sh_count=$(ls -1 fnd_upload_LV*.* |wc -l) problem is if no files matches that, it will give an error "ls: fnd_upload_LV*.*: No such file or directory". how do i avoid having the shell script show that... (2 Replies)
Discussion started by: adshocker
2 Replies

5. UNIX for Dummies Questions & Answers

Counting the number of times a character appears

I am looking for a bash command that counts the number of times a character appears in a file. For example "I am a newbie, trying to learn shell script". Then the command counts the number of e and gives them as 4. Also I want one that counts the number of times a character in a string is replaced.... (2 Replies)
Discussion started by: #moveon
2 Replies

6. Shell Programming and Scripting

Looking for a single line to count how many times one character occurs in a word...

I've been looking on the internet, and haven't found anything simple enough to use in my code. All I want to do is count how many times "-" occurs in a string of characters (as a package name). It seems it should be very simple, and shouldn't require more than one line to accomplish. And this is... (2 Replies)
Discussion started by: Shingoshi
2 Replies

7. Shell Programming and Scripting

Removal of a tag in the xml which occurs mutiple times

Hi, The tag can occur multiple times. I want to remove entire <SeqNum>..</SeqNum> from each line, regardless the values with in this tag. for each line value inside these tags could be different. So please suggest how to do this. Note: Each profile information is in one line. ... (2 Replies)
Discussion started by: Anusha_Reddy
2 Replies

8. UNIX for Dummies Questions & Answers

how to read how many times same result occurs?

Is there a way to read how many times each result occurs in a list, say the list.txt has the results: a c d a f c a d e and I need to know how many times each of them occurs such as : a=3 c=2 ..etc. (5 Replies)
Discussion started by: Iifa
5 Replies

9. Homework & Coursework Questions

Accepting a phrase and counting the number of times that it is repeated in a specific website

1. The problem statement, all variables and given/known data: Develop a shell script that accepts a phrase and counts the number of times that it is repeated in a specific website. Note: Im not sure if it's the whole website, or just a specific page but im guessing its thewhole website. ... (2 Replies)
Discussion started by: Zakerii
2 Replies

10. Shell Programming and Scripting

sed command to replace one value which occurs multiple times

Hi, My Input File : "MN.1.2.1.2.14.1.1" := "MN_13_TM_4" ( 000000110110100100110001111110110110101110101001100111110100011010110111001 ) "MOS.1.2.1.2.13.6.2" := "MOS_13_TM_4" ( 000000110110100100110001111110110110101110101001100111110100011010110111001 ) Like above template,I have... (4 Replies)
Discussion started by: Preeti Chandra
4 Replies

LEARN ABOUT DEBIAN

gappletviewer

GAPPLETVIEWER(1)                                                        GNU                                                       GAPPLETVIEWER(1)

NAME

       gappletviewer - Load and runs an applet

SYNOPSIS

       appletviewer [OPTION]... URL...

       appletviewer [OPTION]... -code CODE

       appletviewer [OPTION]... -plugin INPUT,OUTPUT

DESCRIPTION

       The appletviewer tool loads and runs an applet.

       Use the first form to test applets specified by tag.  The URL should resolve to an HTML document from which the appletviewer will extract
       applet tags.  The APPLET, EMBED and OBJECT tags are supported.  If a given document contains multiple applet tags, all the applets will be
       loaded, with each applet appearing in its own window.  Likewise, when multiple URLs are specified, each applet tag instance is given its
       own window.  If a given document contains no recognized tags the appletviewer does nothing.

               appletviewer http://www.gnu.org/software/classpath/

       Use the second form to test an applet in development.  This form allows applet tag attributes to be supplied on the command line.  Only one
       applet may be specified using the -code option.  The -code option overrides the URL form -- any URLs specified will be ignored.

               appletviewer -code Test.class -param datafile,data.txt

       gcjwebplugin uses the third form to communicate with the appletviewer through named pipes.

OPTIONS

       URL OPTIONS

       -debug
           This option is not yet implemented but is provided for compatibility.

       -encoding CHARSET
           Use this option to specify an alternate character encoding for the specified HTML page.

       APPLET TAG OPTIONS

       -code CODE
           Use the -code option to specify the value of the applet tag CODE attribute.

       -codebase CODEBASE
           Use the -codebase option to specify the value of the applet tag CODEBASE attribute.

       -archive ARCHIVE
           Use the -archive option to specify the value of the applet tag ARCHIVE attribute.

       -width WIDTH
           Use the -width option to specify the value of the applet tag WIDTH attribute.

       -height HEIGHT
           Use the -height option to specify the value of the applet tag HEIGHT attribute.

       -param NAME,VALUE
           Use the -param option to specify values for the NAME and VALUE attributes of an applet PARAM tag.

       PLUGIN OPTION

       -plugin INPUT,OUTPUT
           gcjwebplugin uses the -plugin option to specify the named pipe the appletviewer should use for receiving commands (INPUT) and the one
           it should use for sending commands to gcjwebplugin (OUTPUT).

       DEBUGGING OPTION

       -verbose
           Use the -verbose option to have the appletviewer print debugging messages.

       STANDARD OPTIONS

       -help
           Use the -help option to have the appletviewer print a usage message, then exit.

       -version
           Use the -version option to have the appletviewer print its version, then exit.

       -JOPTION
           Use the -J option to pass OPTION to the virtual machine that will run the appletviewer.  Unlike other options, there must not be a
           space between the -J and OPTION.

BUGS

SEE ALSO

AUTHOR

0.98                                                                2010-07-05                                                    GAPPLETVIEWER(1)
All times are GMT -4. The time now is 04:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy