Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Control-break"ish" in awk
Top Forums UNIX for Dummies Questions & Answers Control-break"ish" in awk Post 302932078 by beca123456 on Monday 19th of January 2015 03:14:34 AM
Old 01-19-2015
Still not working !!!

Using your code:
input:
Code:
1|Bob
3|Bob
Ref|Bob
5|Rick
1|Rick
Ref|Rick

output:
Code:
1|Bob
3|Bob
Ref|Bob|*
5|Rick
1|Rick
Ref|Rick|*

I should get:
Code:
1|Bob
3|Bob
Ref|Bob|*
5|Rick
1|Rick
Ref|Rick

Let's me explain again with another example:
Code:
1|Bob
3|Bob
Ref|Bob
2|Rick
5|Rick
1|Rick
Ref|Rick
7|Paul
Ref|Paul

Here we have 3 groups "Bob", "Rick" and "Paul'.
* 1st group:
1st record, value of $1 is 1 (i.e. <4)
2nd record, value of $1 is 3 (i.e. <4)
=> as all $1 are <4, we can add "*" at the last record of the group (the one starting with Ref)

* 2nd group:
1st record of this group, value of $1 is 2 (i.e. <4)
2nd record of this group, value of $1 is 5 (i.e >4)
=> at least one value of the group is >4, the last record of the group (the one starting with Ref), must remain unchanged (no matter the value of $1 in the 3rd record of the group)

* 3rd group:
1st record of this group, value of $1 is 7 (i.e. >4)
=> the last record of the group (the one starting with Ref), must remain unchanged.

We should then obtain:
Code:
1|Bob
3|Bob
Ref|Bob|*
2|Rick
5|Rick
1|Rick
Ref|Rick
7|Paul
Ref|Paul

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

2. Shell Programming and Scripting

help for saving vertical datas to horizontal with "awk" or "cut"

hi, i have a file having datas like that ./a.txt 12344 12345 12346 12347 ..... ..... ... i want to save this datas to another file like that ./b.txt 12344 12345 12346 12347 ... ... ... i think awk can make this but how? :) waiting for ur help. (3 Replies)
Discussion started by: mercury
3 Replies

3. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

4. Shell Programming and Scripting

"last" in perl vs "break" elsewhere

Is there a functional difference between the two statements? (4 Replies)
Discussion started by: thmnetwork
4 Replies

5. Shell Programming and Scripting

Simplify Bash Script Using "sed" Or "awk"

Input file: 2 aux003.net3.com error12 6 awn0117.net1.com error13 84 aux008 error14 29 aux001.ha.ux.isd.com error12 209 aux002.vm.ux.isd.com error34 21 alx0027.vm.net2.com error12 227 dux001.net5.com error123 22 us008.dot.net2.com error121 13 us009.net2.com error129Expected Output: 2... (4 Replies)
Discussion started by: sQew
4 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

8. Tips and Tutorials

How to do a "Control Break" (Algorithm)

A vast amount of problems asked in "Shell Programming an Scripting" can be traced back to be an application of a basic algorithm called a Control Break. Every programmer - and script writers are programmers nonetheless - should immediately recognize problems of this sort and know how to deal with... (1 Reply)
Discussion started by: bakunin
1 Replies

9. UNIX for Dummies Questions & Answers

Find a string across line break (because of "segmentation fault core dumped")

Hi, thanks to a precedent post, and thanks to the reply of derekludwig of the forum, I have convert my first awk command as : test.txt is : AAAAAGHIJKLAjKMEFJKLjklABCDJkLEFGHIJKL awk -f findstring.awk test.txt > textreturn.txtfindstring.awk is : BEGIN{ SLENGTH = 3 } { ... (3 Replies)
Discussion started by: thewizarde6
3 Replies

10. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

LEARN ABOUT DEBIAN

hdfls

HDFLS(1)						      General Commands Manual							  HDFLS(1)

NAME

       hdfls - list basic information about an HDF file

SYNOPSIS

       hdfls [-o] [-l] [-d] [-v] [-g] [-s] [-h] [-t n] hdf_file

DESCRIPTION

       hdfls provides general information about the tags, reference numbers, and if requested, lengths of the data elements.

OPTIONS

       -o     display the reference numbers in ascending order.

       -l     long format.  Display more information about the file.

       -d     Display offset and length information for each element in the file.

       -v     verbose.	Display annotation and label text, along with the format triggered by the -l flag.

       -g     Group.  List items by group.

       -s     Special elements.  Display detailed information about special elements.

       -d     Display offset and length information for each element in the file.

       -h     Dump DD block information.

       -t n   Tag.  Only list information about the specified tag. Must be followed by a tag number.

EXAMPLES

       A  file called "aa.hdf" contains three items associated with a raster image; the image dimensions, a palette, and the raster image. To dis-
       play information about the contents of this file, the following command is used.

       hdfls aa.hdf

       The following output is displayed:

	       aa.hdf:

       Image Dimensions-8:		       (Raster-8): (tag 200)

	       Ref nos: 1

       Image Palette-8: 		       (Raster-8): (tag 201)

	       Ref nos: 3

       Raster Image-8:		       (Raster-8): (tag 202)

	       Ref nos: 1

       The following displays the same information with the length of each data element:

       hdfls -l aa.hdf

       This would result in the following information being displayed:

	       aa.hdf:

	       Image Dimensions-8:	       (Raster-8)      : (tag 200)

	       Ref no 1 	       4 bytes

	       Image Palette-8: 	       (Raster-8)      : (tag 201)

	       Ref no 3 	       768 bytes

	       Raster Image-8:	       (Raster-8)      : (tag 202)

	       Ref no 1 	       120000 bytes

SEE ALSO

       hdf(5)

								 October 31, 1999							  HDFLS(1)
All times are GMT -4. The time now is 09:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy