Sponsored Content
Top Forums Shell Programming and Scripting Printing from col x to end of line, except last col Post 302752755 by LMHmedchem on Monday 7th of January 2013 01:06:58 PM
Old 01-07-2013
Printing from col x to end of line, except last col

Hello,

I have some tab delimited data and I need to move the last col. I could hard code it,

awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile

but it would be nice to know the syntax to print a range cols.

I know in cut you can do,

cut -f 1,4-8,11-

to print fields 1, 4,5,6,7,8, and from 11 to the end of the line, but I don't know if cut has a variable for the last col like $NF.

Since I am moving $NF from the end, it shouldn't be printed again, but that complexifys things a bit more. If it was printed again, it would be easy enough to get rid of it in a second step, but it seems as if there should be a straightforward way to do this in one step.

Suggestions are appreciated,

LMHmedchem
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Help On col command

Hello Can Any1 tell me the difference between the col command and the col command with the -f option. I tried running both of them but i can't see any difference. Please guide me. (1 Reply)
Discussion started by: rahulrathod
1 Replies

2. Shell Programming and Scripting

Setting Col size

I have a variable in a shell script which is more than 80 characters. 1) I log into SQL plus and populate a variable using 3 queries appended by ,' comma'. ORAINFO=`sqlplus -s << ! / as sysdba set feedback off set heading off select LOG_MODE... (2 Replies)
Discussion started by: yerra
2 Replies

3. UNIX for Dummies Questions & Answers

Info about col command

Hello every1. Can any1 help me with the col command. Wat is a reverse line feed. Which kind of files u need to use the col command. (2 Replies)
Discussion started by: rahulrathod
2 Replies

4. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

5. Shell Programming and Scripting

i can't cut the third col

SW_dist_intr false Enable SW distribution of interrupts True autorestart true Automatically REBOOT OS after a crash True boottype disk N/A False capacity_inc 1.00 ... (7 Replies)
Discussion started by: maxim42
7 Replies

6. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

7. Shell Programming and Scripting

Retrieving data from 65th col (of each line) ?

Hello Friends, I am in situation where I have to note down few SQL queries from specific hexdump format. Here is an example (the query text starts at 65th character on each line) ---------------------- 0x000007FEB0E701C0 : 7365 6C65 6374 2063 7573 746E 6F2C 2020 select custno, ... (9 Replies)
Discussion started by: Sunusernewbie
9 Replies

8. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

9. Shell Programming and Scripting

Merge files by col value

Hi, Please help, this is quite complex, I dont know how to start. The original input files are 10mb in size each. I have multiple files and I want to merge them in the following way. Every file has 4 columns. Col1 and col2 are fixed with respect to each other. In the example value A... (2 Replies)
Discussion started by: alpesh
2 Replies

10. Shell Programming and Scripting

Matrix to 3 col sorted

Hello experts, I have matrices sorted by position, there are 400k rows, 3000 columns. ID CHR POS M1 M2 M3 M4 M5 ID1 1 1 4.6 2.6 2.1 3.5 4.2 ID2 1 100 3.6 2.9 3.2 2.6 2.5 ID3 1 1000 4.1... (9 Replies)
Discussion started by: senhia83
9 Replies
qwavcut(1)							 quelcom man pages							qwavcut(1)

NAME
qwavcut - extract and/or delete parts of a wav file SYNOPSIS
qwavcut [option]... file DESCRIPTION
qwavcut allows to extract and/or delete a fragment of a wav 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 samples contained in the specified cut will be copied. -V, --version show version and exit. CUT OPTIONS
cut options are used to specify at which sample 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 sample and ends at the last sample; there's no default value for size. all the values are treated as a sample number unless a format specifier is used. see the FORMATS section below for information. all values must be positive integer. -b <begin>[<format>], --set-begin-from-eof=<begin>[<format>] begin specifies the first sample 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 sample 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 sample 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 sample 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 samples 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 samples. since most of the times will be difficult to specify a cut in terms of samples, 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 samples. EXAMPLES
here are some examples: to get the last ten seconds of a file: qwavcut -b 10s -o outfile.wav infile.wav four ways of getting the first minute of a file: qwavcut -S -1:0 -o outfile.wav infile.wav qwavcut -S -60 -o outfile.wav infile.wav qwavcut -E 1m -o outfile.wav infile.wav qwavcut -s 1m -o outfile.wav infile.wav four ways of getting the second quarter of a file: qwavcut -S 15:0-30:0 -o outfile.wav infile.wav qwavcut -B 15m -E 30m -o outfile.wav infile.wav qwavcut -s 15m -E 30m -o outfile.wav infile.wav qwavcut -B 15m -s 15m -o outfile.wav infile.wav NOTES
if neither the options --output nor --delete are specified, the program will do nothing. when cutting at the end, a simple truncate call is needed. but when cutting in the middle or in the beginning, all the data behind the cut must be moved ahead and, depending on the amount of the data to be moved, this can be a time consuming operation. BUGS
tests has been done only with 44100 Hz 16 bit stereo files, though it may work with mono/stereo 8/16 bits files. AUTHOR
dmanye@etse.urv.es http://www.etse.urv.es/~dmanye/quelcom/quelcom.html SEE ALSO
qwavinfo(1), qwavjoin(1), qwavsilence(1), qwavfade(1), qwavheaderdump(1) qmp3info(1), qmp3join(1), qmp3cut(1), qmp3check(1), qmp3report(1) quelcom 0.4.0 february 2001 qwavcut(1)
All times are GMT -4. The time now is 05:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy