Sponsored Content
Top Forums Shell Programming and Scripting selecting record by matching in two columns values Post 302556411 by birei on Sunday 18th of September 2011 11:52:10 AM
Old 09-18-2011
Hi,

From the original post, I understand that he wants only the first field, although I'm not sure, so could be wrong. According with Scrutinizer, awk is one of the best tools for this job.

Here my approach:
Code:
$ cut -f1,3 infile | grep -E "john\s+20" | cut -f1

Regards,
Birei
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Selecting rows based on values in columns

Hi My pipe delimited .txt file contains rows with 10 columns. Can anyone advise how I output to file only those rows with the letters ‘ci' as the first 2 characters in the 3rd column ? Many thanks (4 Replies)
Discussion started by: malts18
4 Replies

2. Programming

selecting values of date

In a table, date is stored in a column as "2011-01-4". If I write query to get the dates > "2011-01-06" , then the date "2011-01-4" is also listed. The date stored in the column is a varchar datatype. So how can I make a query to not display the date "2011-01-4" ? Is there any solution ? Thank... (4 Replies)
Discussion started by: gameboy87
4 Replies

3. Programming

Selecting array values

I have two arrays DIST(1:NCOF) and X(1:NX) Let NCOF = 5 and NX = 15, with DIST = and X = I want to create an array that puts a zero if DIST is outside the region in X, otherwise putting 1. In this example I should get RES = Using DIST = would give RES = The values in... (6 Replies)
Discussion started by: kristinu
6 Replies

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Hi All, I have two sets of files. Set 1: 100 text files with extension .txt with names like 1.txt, 2.txt, 3.txt until 100.txt Set 2: One big file with extension .dat The text files have some records in columns like this: 0.7316431 82628 0.7248189 82577 0.7248182 81369 0.7222999... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

5. Shell Programming and Scripting

[Solved] Need Help on Selecting a particular record

Hi Guys, Following is my Input file. Time : Wed Nov 16 02:32:09 2011 Type : INFO User : dsadm Message : Oracle_Connector_2: The connector generated the following TRUNCATE TABLE statement at runtime: TRUNCATE TABLE CANADA_INDUSTRY_OBJECTIVES. Time : Wed Nov 16... (4 Replies)
Discussion started by: mac4rfree
4 Replies

6. Shell Programming and Scripting

Selecting lowest and highest values in columns 1 and 2, based on subsets in column 3

Hi, I have a file with the following columns: 361459 447394 CHL1 290282 290282 CHL1 361459 447394 CHL1 361459 447394 CHL1 178352861 178363529 AGA 178352861 178363529 AGA 178363657 178363657 AGA Essentially, using CHL1 as an example. For any line that has CHL1 in... (2 Replies)
Discussion started by: hubleo
2 Replies

7. Shell Programming and Scripting

Print columns matching to specific values

Hello Friends, I have a CDR file and i need to print out 2 columns with their field position which matches to some constant values, a part of input file CZ=1|CZA=1|DIAL=415483420001|EE=13|ESF=1|ET=|FF=0|9|MNC=99|MNP=9041|MTC=0|NID=2|NOA=international|ON=1| OutPut ... (3 Replies)
Discussion started by: EAGL€
3 Replies

8. Shell Programming and Scripting

Selecting lines having same values for first two columns

Hello to all. This is first post. Kindly excuse me if I do not adhere to any rules and regulations of this forum. I have a file containing some rows with three columns each per row(separeted by a space). There are certain rows for which first two columns have same value but the value in... (6 Replies)
Discussion started by: manojmalhotra13
6 Replies

9. Shell Programming and Scripting

Read record from the text file contain multiple separated values & assign those values to variables

I have a file containing multiple values, some of them are pipe separated which are to be read as separate values and some of them are single value all are these need to store in variables. I need to read this file which is an input to my script Config.txt file name, first path, second... (7 Replies)
Discussion started by: ketanraut
7 Replies

10. Shell Programming and Scripting

Help with shell script: selecting rows that have the same values in two columns

Hello, everyone I am beginner for shell programming. I want to print all lines that have the same values in first two columns data: a b 1 2 a a 3 4 b b 5 6 a b 4 6 what I expected is : a a 3 4 b b 5 6 but I searched for one hour in... (2 Replies)
Discussion started by: nengcheng
2 Replies
qmp3cut(1)							 quelcom man pages							qmp3cut(1)

NAME
qmp3cut - extract and/or delete parts of a mp3 file SYNOPSIS
qmp3cut [option]... file DESCRIPTION
qmp3cut allows to extract and/or delete a fragment of a mp3 file. some parameters must be supplied in order to define the start/size/end cut points and what to do then: either the fragment must be copied to another file or erased from the file (or both) GENERAL OPTIONS
-d, --delete deletes the fragment from the file. if option --output is used, deletion action is always done after fragment extraction. -h, --help show a brief help and exit. -o <outfile>, --output=<outfile> outfile is the file where the frames contained in the specified fragment will be copied. -v, --verbose verbose. -V, --version show version and exit. CUT OPTIONS
cut options are used to specify at which frame the fragment begins (options -b or -B), ends (options -e and -E), or which size it has (option -s). at least, one cut option must be specified. neither the options -b and -B, and the options -e and -E can be used together; also, a begin, end and size option can be used at the same time. by default, the fragment begins at the first frame and ends at the last frame; there's no default value for size. all the values are treated as a frame number unless a format specifier is used. see the FORMATS section below for information. values must be positive integer. -b <begin>[<format>], --set-begin-from-eof=<begin>[<format>] begin specifies the first frame of the file that belongs to the cut counting from the end of the file. -B <begin>[<format>], --set-begin=<begin>[<format>] begin specifies the first frame of the file that belongs to the cut counting from the beginning of the file. -e <end>[<format>], --set-end-from-eof=<end>[<format>] end specifies the last frame of the file that belongs to the cut counting from the end of the file. -E <end>[<format>], --set-end=<end>[<format>] end specifies the last frame of the file that belongs to the cut counting from the beginning of the file. -s <size>[<format>], --set-size=<size>[<format>] size specifies the number of frames contained in the cut. -S <begin>-<end>, --slice <begin>-<end> slice specifies the starting and ending points of the cut as a timeslice, which is to say, two time specifications ([[h:]m:]s[.ms]) joined by a hyphen. FORMATS
cut options can have also an optional modifier. if this modifier is not used, then the value provided with the corresponding cut option will be interpreted as a number of frames. since most of the times will be difficult to specify a cut in terms of frames, the following modifiers are provided: j value is interpreted as milliseconds. m value is interpreted as minutes. s value is interpreted as seconds. b value is interpreted as bytes. k value is interpreted as kbytes (1024 bytes). M value is interpreted as megabytes (1024 kbytes). in either case, the values specified will be rounded to get an integer number of frames. EXAMPLES
here are some examples: to get the last ten seconds of a file: qmp3cut -b 10s -o outfile.mp3 infile.mp3 two ways of getting the first minute of a file: qmp3cut -E 1m -o outfile.mp3 infile.mp3 qmp3cut -s 1m -o outfile.mp3 infile.mp3 three ways of getting the second quarter of a file: qmp3cut -S 15:0-30:0 -o outfile.mp3 infile.mp3 qmp3cut -B 15m -E 30m -o outfile.mp3 infile.mp3 qmp3cut -s 15m -E 30m -o outfile.mp3 infile.mp3 qmp3cut -B 15m -s 15m -o outfile.mp3 infile.mp3 NOTES
if neither the options --output nor --delete are specified, the program will do nothing. BUGS
usually, the mpg123 player (and any other app mp3-read capable) report messages in the way like "cannot rewind by XXX bytes" where XXX is a negative value on streams extracted with qmp3cut. this is due to frame dependency (frame decoding depends sometimes of neighbourhood frames when bit reservoir technique is used at encoding time) and possibly will be corrected in a (near?) future. there's no support for variable bit rate (vbr) files. tests have been done only with mpeg version 1 layer iii streams, though it may (or not) work with other versions/layers. AUTHOR
dmanye@etse.urv.es http://www.etse.urv.es/~dmanye/quelcom/quelcom.html SEE ALSO
qmp3info(1), qmp3join(1), qmp3check(1), qmp3report(1) qwavinfo(1), qwavjoin(1), qwavcut(1), qwavsilence(1), qwavfade(1), qwavheaderdump(1) quelcom 0.4.0 february 2001 qmp3cut(1)
All times are GMT -4. The time now is 06:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy