awk to select rows based on condition on column Post: 302368007

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk - how to select the column based on day of month

Problem, How can you pass today's date (eg) 18 into Awk and select the field representing the 18th column? I have an output that I want to interact with based on what day it is information=0:0 192:0 5436:0 22:99 0:0 0:0 1234:0 1359:09 DAY=date'+%d' numbrs=`$information | awk...

2. Shell Programming and Scripting

Select rows where the 3rd column value is over xx

Hi All, I've got a text file which is Postcode,Postcode, Travel_time and I want to select all of the rows where the 3rd column value is over 255. Can someone show me the magic on how to do this? Originally it did contain 4 columns but i've managed to strip out the first 3 using: cat textfile |...

3. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Hi, I'm using AIX(ksh shell). > cat temp.txt "a","b",0 "c",bc",0 "a1","b1",0 "cc","cb",1 "cc","b2",1 "bb","bc",2 I want the output as: "a","b","c","bc","a1","b1" "cc","cb","cc","b2" "bb","bc" I want to combine multiple lines into single line where third column is same. Is...

4. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30...

5. Shell Programming and Scripting

Select distinct rows in a file by last column

Hi, I have the following file: LOG:015608::ERR:2310:map_spsrec:Invalid parameter LOG:015608::ERR:2471:map_dgdrec:Invalid parameter LOG:015608::ERR:2487:map_nnmrec:Invalid number LOG:015608::ERR:2310:map_nmrec:Invalid number LOG:015608::ERR:2438:map_nmrec:Invalid number As a delimiter I...

6. Shell Programming and Scripting

Need to select some column from file1 if condition match.

I have two files file1.txt and file2.txt. want to print some column(number,status,date1,date2,description(descrption column end before category column start with'Oracle Services') and assigned_to column from file1.txt ...If the assigned_to name in file2.txt matches with assinged_to name in...

7. Shell Programming and Scripting

Convert rows to columns based on condition

I have a file some thing like this: GN Name=YWHAB; RC TISSUE=Keratinocyte; RC TISSUE=Thymus; CC -!- FUNCTION: Adapter protein implicated in the regulation of a large CC spectrum of both general and specialized signaling pathways GN Name=YWHAE; RC TISSUE=Liver; RC ...

8. Shell Programming and Scripting

awk to ignore multiple rows based on a condition

All, I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below. Key,Check A,1 A,2 A, A,4 B,0 B,1 B,2 B,3 B,4 .... million rows. My requirement is to delete all the rows corresponding to all the keys which ever has at least one...

9. UNIX for Advanced & Expert Users

Conversion of rows to columns using awk based om column value

HI, My Input file data is dn:adcfgeneral id:13343 Name:xxxxxx Password:iutyerwuitywue wpuwt tuiytruityrutyrwtyrwp dn:cdferwjyyyy id:3875 Name:yyyy Password :hgfdsjkfhdsfkdlshf dshfkldshfdklsfh interset:uiuiufj My output should be ...

10. Shell Programming and Scripting

awk to select lines with maximum value of each record based on column value

Hello, I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record? Input: A1 chr5D 634 7 82 707 A2 chr5D 637 6 82 713 A3 chr5D 637 5 82 713 A4 chr5D 626 1 82 704...

LEARN ABOUT DEBIAN

icecream

ICECREAM(1)							     icecream							       ICECREAM(1)

NAME

       icecream - download icecast and shoutcast streams, redirecting all fetched content to stdout and/or to disk at the same time

SYNOPSIS

       icecream [OPTIONS] URL [URL..]

DESCRIPTION

       icecream is a lightweight, non-interactive, stream download utility.  It connects to icecast and shoutcast servers or direct stream URLs,
       and redirects all fetched content to stdout and/or to media files on your disk.

       Listen to the stream piping the output to a stdin-capable media player.	Save the stream to a named file or split it into different tracks.
       It is possible to redirect the stream and save it to disk at the same time.

       icecream is able to parse pls and m3u playlists, and to download mp3 and ogg direct stream URLs. If the stream is anonymous it will be
       saved as 'stream-time.mp3', where time is actual timestamp.

OPTIONS

       -h, --help
	       Print a help message describing all options

       -q, --quiet
	       Turn off output

       -v, --verbose
	       Be verbose

       -t, --tracks
	       Split stream into tracks (if possible)

       --name=NAME
	       Save the stream to file specified by NAME. Format codes starting with "%" will be replaced. See the date command for valid format
	       codes.

       --stop=N[units]
	       Stop downloading the stream after N kb/mb/min/songs

       --user-agent=AGENT
	       Set user-agent header to AGENT

       --stdout
	       Output stream to stdout (implies -q)

       --sync  Turn syncing on, required for some mpeg players that read from stdin

       --debug Turn on debugging outputs

EXAMPLES

       Streaming to mpg123
	       icecream --stdout http://radio.com/playlist.pls | mpg123 -

       Split stream into different tracks
	       icecream -t http://metal.org/radio.pls

       Split stream into tracks and play with vlc at the same time
	       icecream -t --stdout http://streaming.com/playlist.pls | vlc file:/dev/stdin

       Prepare a 74 minute CD
	       icecream -t --stop 74min http://trace.net/playlist.m3u

       Use a filename with today's date as output
	       icecream -q --name 'radio_%Y_%m_%d' --stop 60min http://radio.com/playlist.pls

BUGS

       You are welcome to send bug reports about icecream to our mailing list.	Feel free to visit http://icecream.sourceforge.net

AUTHOR

       Written by Gil Megidish <gil at megidish.net>

1.3								    2008-04-28							       ICECREAM(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk - how to select the column based on day of month

Discussion started by: Gizmo1007

2. Shell Programming and Scripting

Select rows where the 3rd column value is over xx

Discussion started by: gman

3. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Discussion started by: samuelray

4. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

Discussion started by: A-V