Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Append no of times a column is repeated at the end Post 302919673 by RavinderSingh13 on Friday 3rd of October 2014 02:25:36 AM
Old 10-03-2014
Quote:
Originally Posted by tech_frk
Hi folks,

Iam working on a bash script, i need to print how many times column 2 repeated at the end of each line.

Input.txt
Code:
COL1 COL2 COL3 COL4
 1 XX 45 N
 2 YY 34 y
 3 ZZ 44 N
 4 XX 89 Y
 5 XX 45 N
 6 YY 84 D
 7 ZZ 22 S

Output.txt
Code:
COL1 COL2 COL3 COL4 COL5
 1 XX 45 N 3
 2 YY 34 y 2
 3 ZZ 44 N 2
 4 XX 89 Y 3
 5 XX 45 N 3
 6 YY 84 D 2
 7 ZZ 22 S 2

i.e in column 2 the repeatation of XX is 3 , YY is 2 and ZZ is 2, which has to appended at the end of each line.

appreciate your help.
Hello tech_frk,

Following may help you in same.

Code:
 awk 'NR==1{$(NF+1)="COL5";print $0} FNR==NR && NR>1 {X[$2]++;Y[$2]=$0 OFS X[$2];next} ($2 in Y){print Y[$2]}' Input_file Input_file

Output will be as follows.

Code:
COL1 COL2 COL3 COL4 COL5
 5 XX 45 N 3
 6 YY 84 D 2
 7 ZZ 22 S 2
 5 XX 45 N 3
 5 XX 45 N 3
 6 YY 84 D 2
 7 ZZ 22 S 2

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how many times does this repeated sequence exist

need a script to determine daily how many times does the below repeated sequence exist in a log file, and if it shows failure to connect in the same file 200 PORT Command successful. 150 Opening BINARY mode data connection for rgr016.daily.0305. 226 Transfer complete. local: rgr016.daily.0306... (3 Replies)
Discussion started by: lichento
3 Replies

2. Shell Programming and Scripting

Append char to the end of string from Nth column

I'm sure this is easy to do but I can't find a one line command with awk or sed to append a char to the end of the string from Nth column. Any sugestion please? Thanks (2 Replies)
Discussion started by: cabrao
2 Replies

3. Shell Programming and Scripting

Append some text to a file multiple times

Hi, I have a text file like Version=abc Tab=1 URL GOTO=www.abc.com/board=1 some text... I want to run a loop x no of times and append to the text file above text but URL GOTO should be www.abc.com/board=2 then 3,4...etc till x. Kindly help (2 Replies)
Discussion started by: krabu
2 Replies

4. UNIX for Dummies Questions & Answers

To get the total of how many times the pattern is repeated.

Hi, I need the total of how many times the pattern is being repeated in a particular file. I tried with grep as below, but no go. grep -c best sample Contents of Sample file: ----------------------- This is the best site I have never come across. The best one indeed. Very best... (8 Replies)
Discussion started by: venkatesht
8 Replies

5. UNIX for Dummies Questions & Answers

Extracting column if above certain values and repeated over a number of times continuously

Hi I am new to the forum and would like to ask: i have a file in form with thousands of column id.1 A01 A01 A68 A68 id.2 A5 A5 A3 A3 1001 0 0 0.136 0.136 1002 0 0 0.262 0.183 1003 0 0 0.662 0.662 1004 0 0 ... (9 Replies)
Discussion started by: newbeeuk
9 Replies

6. Shell Programming and Scripting

How to print the lines which are repeated 3 times in a file?

Hello All, I have a file which has repeated lines. I want to print the lines which are repeated three times. Please help. (3 Replies)
Discussion started by: ailnilanjan
3 Replies

7. 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

8. Shell Programming and Scripting

To append new data at the end of each line based on substring of last column

Hi guys, I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column. Input file xxx.csv: U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0 U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0... (5 Replies)
Discussion started by: null7
5 Replies

9. UNIX for Beginners Questions & Answers

Export lines that have first entry repeated 5 times or above

Dears i want to extract lines only that have first entry repeated 3 times or above , ex data : -bash-3.00$ cat INTCONT-IS.CSV M205-00-106_AMDRN:1-0-6-22,12-662-4833,intContact,2016-11-15 02:32:16,50 M205-00-106_AMDRN:1-0-23-17,12-616-0462,intContact,2016-11-15 02:32:23,50... (5 Replies)
Discussion started by: is2_egypt
5 Replies

10. Shell Programming and Scripting

Remove duplicate lines which has been repeated 4 times

Remove duplicate lines which has been repeated 4 times attached test.txt below command tried and not getting expect output. for i in `cat test.txt | uniq` do num=`cat test.txt | grep $i | wc -l` echo $i $num done test.txt ... (17 Replies)
Discussion started by: Kalia
17 Replies
indicator(1F)							   FMLI Commands						     indicator(1F)

NAME
indicator - display application specific alarms and/or the "working" indicator SYNOPSIS
indicator [-b [n]] [-c column] [-l length] [-o] [-w] [string]... DESCRIPTION
The indicator function displays application specific alarms or the "working" indicator, or both, on the FMLI banner line. The argument string is a string to be displayed on the banner line, and should always be the last argument given. Note that string is not automatically cleared from the banner line. OPTIONS
-bn The -b option rings the terminal bell n times, where n is an integer from 1 to 10. The default value is 1. If the terminal has no bell, the screen is flashed instead, if possible. -c column The -c option defines the column of the banner line at which to start the indicator string. The argument column must be an integer from 0 to DISPLAYW-1. If the -c option is not used, column defaults to 0 . -l length The -l option defines the maximum length of the string displayed. If string is longer than length characters, it will be trun- cated. The argument length must be an integer from 1 to DISPLAYW. If the -l option is not used, length defaults to DISPLAYW. Note that if string doesn't fit it will be truncated. -o The -o option causes indicator to duplicate its output to stdout . -w The -w option turns on the "working" indicator. EXAMPLES
Example 1 A sample output of the indicator command. When the value entered in a form field is invalid, the following use of indicator will ring the bell three times and display the word WRONG starting at column 1 of the banner line. invalidmsg=`indicator -b 3 -c 1 "WRONG"` To clear the indicator after telling the user the entry is wrong: invalidmsg=`indicator -b 9 -c 1 "WRONG"; sleep 3; indicator -c 1 " "` In this example the value of invalidmsg (in this case the default value Input is not valid), still appears on the FMLI message line. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
attributes(5) SunOS 5.11 5 Jul 1990 indicator(1F)
All times are GMT -4. The time now is 04:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy