Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Combining AWK statements
Top Forums Shell Programming and Scripting Combining AWK statements Post 302526185 by vnayak on Monday 30th of May 2011 06:16:55 PM
Old 05-30-2011
Power Combining AWK statements
Hello UNIX Community,

I have file that contains the following data:

testAwk2.csv


Code:
rabbit penguin goat 
 giraffe emu ostrich 
 hyena elephant panda
 dog cat pig
 lizard snake antelope
 platypus tiger cheetah
 lion rhino spider

I then find the character length of the second field:

Code:
awk '{print $0, length($2)}' testAwk2.csv 

 rabbit penguin goat  7
 giraffe emu ostrich  3
 hyena elephant panda 8
 dog cat pig 3
 lizard snake antelope 5
 platypus tiger cheetah 5
 lion rhino spider  5

Now I want to only display the fields with more then 3 characters:

Code:
awk '{print $0, length($2)}' testAwk2.csv > testAwk3.csv | awk '$4 > 3' testAwk3.csv > testAwk4.csv

cat testAwk4.csv 

 rabbit penguin goat  7
 hyena elephant panda 8
 lizard snake antelope 5
 platypus tiger cheetah 5
 lion rhino spider  5

This produces the correct answer so no problem there. But is there a way to combine the two awk statements and sort the third field alphabetically at the same time? This is so I can output the operation into just one file rather then
then the many I have created above.

I really would appreciate your help with this.

Many Thanks,

Vnayak
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk compound statements

how can i use two or multiple statements in the if part of an awk code for example i want to check two flag if they are true i will write some print operations and increase the counter. here is the c version of the code that i want to write: counter=0; if (flag1==1 && flag2==0) {... (7 Replies)
Discussion started by: gfhgfnhhn
7 Replies

2. Shell Programming and Scripting

Help a newbie please with awk if else statements

Hi, Despite reading the Conditional Statements chapter in the O'Reilly Sed & Awk book several times and looking at numerous examples, I cannot for the life of me get any kind of if ... else statement to work in my awk scripts! My scripts work perfectly (as they are written at least) and do what... (4 Replies)
Discussion started by: jonathanm
4 Replies

3. Shell Programming and Scripting

Combine awk statements

I have an awk statement that works but I am calling awk twice and I know there has to be a way to combine the two statements into one. The purpose is to pull out just the ip address from loopback1. cat config.txt | nawk 'BEGIN {FS="\n"}{RS="!"}{if ( $0 ~ "interface loopback1" ) print$4}' | nawk... (5 Replies)
Discussion started by: numele
5 Replies

4. Shell Programming and Scripting

Combining awk statements

I have a pretty simple script below: #!/bin/sh for i in *.cfg do temp=`awk '/^InputDirectory=/' ${i}` input_dir=`echo ${temp} | awk '{ print substr( $0, 16) }'` echo ${input_dir} done As you can see its opening each cfg file and searching for the line that has "InputDirectory="... (3 Replies)
Discussion started by: ssbsts
3 Replies

5. UNIX for Dummies Questions & Answers

AWK w/ if statements failing.

I'm converting some code from ksh on my macbook (Version M 1993-12-28 s+) to an older solaris machine with ksh 88. I can't seem to figure out this line, it worked on the new shell version. set -A combo -- $(for x in ${ImageIDs}; do nawk -v s=$x 'if($2 == s) getline ; getline if ($1 ==... (2 Replies)
Discussion started by: nerdcurious
2 Replies

6. UNIX for Dummies Questions & Answers

Combine two awk statements into one

Hi, I have the following two awk statements which I'd like to consolidate into one by piping the output from the first into the second awk statement (rather than having to write kat.txt out to a file and then reading back in). awk 'BEGIN {FS=OFS=" "} {printf("%s ", $2);for (x=7; x<=10;... (3 Replies)
Discussion started by: kasan0
3 Replies

7. Shell Programming and Scripting

combining multiple sed statements

I need to run a cronjob that will monitor a directory for files with a certain extension, when one appears I then need to run the below scripts How do I go about combining the following sed statements into one script? and also retain the original filename.? sed 's/71502FSC1206/\n&/g' # add a... (2 Replies)
Discussion started by: firefox2k2
2 Replies

8. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}... (7 Replies)
Discussion started by: SkySmart
7 Replies

9. Shell Programming and Scripting

Nested awk Statements

Hello again everyone, yes, I'm back again for more help! So I'm attempting to read two separate files and generate some XML code from that. My current code is: BEGIN { print "<?xml version=\"1.0\" encoding=\"utf-8\">" print "<Export>" } { x=1; print "<section name=\"Query" NR "\">"... (5 Replies)
Discussion started by: Parrakarry
5 Replies

10. Shell Programming and Scripting

awk with many if statements

Hi What is the right structure to use awk with multiple If statements The following code doesn't work # awk ' { A = $1 } END { for ( i = 1; i <= c; i++ ) { if ( A == 236 && A ==199... (7 Replies)
Discussion started by: khaled79
7 Replies

LEARN ABOUT DEBIAN

rabbit

RABBIT(1)							      rabbit								 RABBIT(1)

NAME

       rabbit - presentation tool using RD, simple text format

SYNOPSIS

       rabbit [options] [SOURCE_INFOS]

DESCRIPTION

       Theme

       -I, --include=PATH
	      Add [PATH] to load path.

       -t, --theme=THEME
	      Use [THEME] as theme.  (default)

       --comment-theme=THEME
	      Use [THEME] for comment.	()

       --allotted-time=TIME
	      Use [TIME] as allotted time.  ()

       Source

       -T, --type=TYPE
	      Specify source type as [TYPE].  Select from [auto, argf, file, memory, slideshare, uri].	Note: case insensitive.  (auto)

	      When select ARGF specify none (get from STDIN) or [FILE_NAMES] as [SOURCE_INFOS].

	      When select File specify [FILENAME] as [SOURCE_INFOS].

	      When select Memory specify [FILENAME_OR_NOT] as [SOURCE_INFOS].

	      When select SlideShare specify [USER] and [TITLE] as [SOURCE_INFOS].

	      When select URI specify URI as [SOURCE_INFOS].

       -e, --encoding=ENCODING
	      Specify source encoding as [ENCODING].  (auto)

       -B, --base=BASE
	      Specify base URI or path of source as [BASE].  (auto)

       Initial state

       -f, --[no-]full-screen
	      Toggle full screen mode.	(off)

       --[no-]index-mode
	      Toggle index mode.  (off)

       Size

       -g, --geometry=GEOMETRY
	      Set window geometry [GEOMETRY].  Format: WIDTHxHEIGHT+X+Y (nil)

       -w, --width=WIDTH
	      Set window width to [WIDTH].  (800)

       -h, --height=HEIGHT
	      Set window height to [HEIGHT].  (600)

       -S, --size=WIDTH,HEIGHT
	      Set window width and height to [WIDTH] and [HEIGHT].  (800,600)

       Save

       -s, --save-as-image
	      Save as image and exit.

       -i, --saved-image-type=TYPE
	      Specify saved image type as [TYPE].  (png)

       -bBASE_NAME,
	      Specify saved image base name as [BASE_NAME].

       --saved-image-base-name
	      (Title of slide)

       --saved-image-basename

       --[no-]output-html
	      Output HTML for viewing saved images.  (false)

       --[no-]output-index-html
	      Output index HTML for navigating slides.	(false)

       --rss-base-uri=URI
	      Specify base URI of RSS as [URI].  RSS is generated only when HTML is output.  ()

       --source-filename=FILENAME
	      Specify source filenam as [FILENAME].  ()

       Print

       -p, --print
	      Print and exit.

       -o, --output-filename=FILENAME
	      Specify printed out filename as [FILENAME].  (#{Title of slide}.pdf)

       --slides-per-page=SLIDES
	      Set slides per page.  (1)

       --[no-]draw-scaled-image
	      Draw scaled image.  Better look for displaying but lesser look for printing.  (true)

       Paper

       --paper-width=WIDTH
	      Set paper width to [WIDTH] Pt.  (landscape A4 width)

       --paper-height=HEIGHT
	      Set paper height to [HEIGHT] Pt.	(landscape A4 height)

       --paper-size=WIDTH,HEIGHT
	      Set paper width and height to [WIDTH] Pt and [HEIGHT] Pt.  (landscape A4 size)

       Margin

       --margin-left=MARGIN
	      Set left margin for slides per page mode print.  (auto)

       --margin-right=MARGIN
	      Set right margin for slides per page mode print.	(auto)

       --margin-top=MARGIN
	      Set top margin for slides per page mode print.  (auto)

       --margin-bottom=MARGIN
	      Set bottom margin for slides per page mode print.  (auto)

       --margin={ [ALL] | [TOP_BOTTOM],[LEFT_RIGHT] | [TOP],[LEFT_RIGHT],[BOTTOM] | [TOP],[RIGHT],[BOTTOM],[LEFT]}
	      Set margin for slides per page mode print.

       --page-margin-left=MARGIN
	      Set left page margin.  (auto)

       --page-margin-right=MARGIN
	      Set right page margin.  (auto)

       --page-margin-top=MARGIN
	      Set top page margin.  (auto)

       --page-margin-bottom=MARGIN
	      Set bottom page margin.  (auto)

       --page-margin={[ALL]|[TOP_BOTTOM],[LEFT_RIGHT]|[TOP],[LEFT_RIGHT],[BOTTOM]|[TOP],[RIGHT],[BOTTOM],[LEFT]}
	      Set page margin.

       dRuby

       --[no-]use-druby
	      Specify whether to use dRuby.  (true)

       --druby-uri=URI
	      Specify dRuby URI.  (druby://127.0.0.1:10101)

       --[no-]output-druby-uri
	      Specify whether to output dRuby URI.  (false)

       SOAP

       --[no-]use-soap
	      Specify whether to use SOAP.  (false)

       --soap-host=HOST
	      Specify SOAP host as [HOST].  (0.0.0.0)

       --soap-port=PORT
	      Specify SOAP port as [PORT].  (10103)

       XML-RPC

       --[no-]use-xmlrpc
	      Specify whether to use XML-RPC.  (false)

       --xmlrpc-host=HOST
	      Specify XML-RPC host as [HOST].  (0.0.0.0)

       --xmlrpc-port=PORT
	      Specify XML-RPC port as [PORT].  (10104)

       Server

       --[no-]server
	      Specify whether to run as server.  (false)

       Public level

       --public-level=LEVEL
	      Specify public level.  Select from the following: [

	      strict, move, read-size, change-size, size, read-source, change-source, source, control, all

	      ] (all)

       Comment

       --comment-source=FILE
	      Deprecated. Just ignored.  Specify initial comment source.  (default source)

       --comment-encoding=ENCODING
	      Deprecated. Just ignored.  Specify comment source encoding.  (auto)

       Migemo

       --migemo-dictionary-search-path=PATH1,PATH2,...
	      Specify search paths for Migemo static dictionary.  (/usr/share, /usr/local/share)

       --migemo-dictionary-name=NAME
	      Specify static dictionary name for Migemo.  (migemo-dict)

       3D

       --[no-]use-gl
	      Specify whether to use OpenGL if available.  (false)

       Display

       --[no-]keep-above
	      Specify whether to keep above window.  (false)

       Others

       --[no-]show-native-window-id Show a native window ID of the Rabbit window if available.
	      e.g. The ID is the ID of X resource on X window system.  (false)

       Common options

       --locale-dir=DIR
	      Specify locale dir as [DIR].  (auto)

       --logger-type=TYPE
	      Specify logger type as [TYPE].  Select from [stderr, gui].  (STDERR)

       --log-level=LEVEL
	      Specify log level as [LEVEL].  Select from [debug, info, warning, error, fatal, unknown].  (info)

       --help Show this message.

       --version
	      Show version.

rabbit 1.0.7							     June 2012								 RABBIT(1)
All times are GMT -4. The time now is 10:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy