Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Selectively Reformating a file using AWK
Top Forums UNIX for Advanced & Expert Users Selectively Reformating a file using AWK Post 302300167 by vgersh99 on Monday 23rd of March 2009 11:33:58 AM
Old 03-23-2009
# default fields '2 5 8'
nawk -f sda.awk myFile

# specified fields: '1 3 9'
nawk -v fld='1 3 9' -f sda.awk myFile

sda.awk:
Code:
BEGIN {
  fld=(fld=="")? "2 5 8":fld
  n=split(fld, a, FS)
}
{
     rec=(rec=="")?$0:rec OFS $0
}
!(FNR%3){
     rN=split(rec, recA, OFS)
     rec=""
     for(i=1; i<=n; i++)
       printf("%s%c", recA[a[i]], (i==n) ? ORS : OFS)
}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help on awk.. reformating a file

Hello, I am having a trouble with awk attempting to reformat a two columns file , such as below: 201 84 201 370 201 544 201 600 213 99 213 250 213 431 220 65 220 129 220 338 220 408 220 501 220 550 231 101 231 350 What I need to do is is to add a third column containing a... (4 Replies)
Discussion started by: Martian
4 Replies

2. Shell Programming and Scripting

Selectively splitting a file with C-shell?

I have a rather long csh script that works, but it's terribly ungraceful and takes a while from various loops. I only know enough code to get myself into trouble, so I'm looking for some guidance. I have a large file that is separated at intervals by the same line, like this: ... (2 Replies)
Discussion started by: fusi0n
2 Replies

3. Shell Programming and Scripting

awk - reformating rows into columns

looking to do the following... What the data looks like server1 02/01/2008 groups 10 server1 03/01/2008 groups 15 server1 04/01/2008 groups 20 server2 02/01/2008 users 50 server2 03/01/2008 users 75 server2 04/01/2008 users 100 server2 04/01/2008 users 125 What I would like the... (1 Reply)
Discussion started by: jmd2004
1 Replies

4. UNIX for Dummies Questions & Answers

Removing selectively the last character from a file

Dear Members, Problem is suppose i have 50 lines in a file, 40 lines last character is "\" and the remaining 10 lines are good(i mean these 10 lines do not have "\" character) How can i remove this character from the file. Thanks (1 Reply)
Discussion started by: sandeep_1105
1 Replies

5. Shell Programming and Scripting

Reformating ascii file with awk

Hello, I've a lot of ascii files that I would like to reformat : One of files's column (for exemple $5) contains increasing numbers (see exemple) : $5= 1 1 1 1 1 2 2 2 2 3 3 (2 Replies)
Discussion started by: Caribou
2 Replies

6. Shell Programming and Scripting

Selectively Find/Replace in a file?

I have a file that is HTML encoded. Each line has something like this on each line.. <href=http://link.com/username.aspx>username </a> more info.. <a href=http://link.com/info1.aspx>info1</a> more code... <a href=http://link.com/info2.aspx>info2</a> I have one goal really.. to clean up the... (2 Replies)
Discussion started by: dragin33
2 Replies

7. Shell Programming and Scripting

Splitting & reformating a single file

I have a bif text file with the following format: d1_03 fr:23 d1_03 fr:56 d1_03 fr:67 d1_03 fr:78 d1_01 fr:35 d1_01 fr:29 d1_01 fr:45 d2_09 fr:34 d2_09 fr:78 d3_98 fr:90 d3_98 fr:104 d3_98 fr:360 I have like thousands of such lines I want to reformat this file based on column 1... (3 Replies)
Discussion started by: Lucky Ali
3 Replies

8. Shell Programming and Scripting

Awk or Perl - to selectively merge two files.

I have two files, these have to be selectively merged into two other files. In addition there will require to be a edit to the last field, where the date format is changed. The first file is a csv file with around 300k lines the data is now nearly 20 years old and I have been asked to move this... (7 Replies)
Discussion started by: gull04
7 Replies

9. Shell Programming and Scripting

How to remove spaces from a file selectively?

Hi i have a file in which i am doing some processing. The code is as follows: #!/bin/ksh grep DATA File1.txt >> File2.txt sed 's/DATA//' File2.txt | tr -d ‘ ‘ >> File4.xls As you can see my output is going in a xl file.The output consist of four columns/feilds out of which the first... (20 Replies)
Discussion started by: Sharma331
20 Replies

10. UNIX for Dummies Questions & Answers

Selectively extracting entries from FASTA file

I would like to extract all entries containing the following patterns: ccccta & ccccccccc from the following infile: >P39PT-1224_Freq_900 cccctacgacggcattggtaatggctcccgcaagccatctctcttcagccaagg >P39PT-784_Freq_2 cccctacgacggcattggtaatggcacccgcaagccatctctcttccccccccc >P39PT-678_Freq_5... (4 Replies)
Discussion started by: Xterra
4 Replies

LEARN ABOUT REDHAT

rec

play(1) 						      General Commands Manual							   play(1)

NAME

       play - play any sound file to audio device

       rec  - record audio to any sound file format

SYNOPSIS

       play [fopts] infile [effect]

       rec [fopts] outfile [effect]

DESCRIPTION

       This manual page briefly documents the play and rec commands.

       play  and  rec are programs that allow you to play and record different types of sound files from the command line.  They are front ends to
       the more general sox(1) package.  Normally, the play command will automatically detect the type and other parameters of the  soundfile.	If
       it can't do so, the parameters can be changed through options.

OPTIONS

       A summary of common options are included below.	For a complete description of options and their values, see the sox(1) man page.

       -c [channels], --channels=[channels]
	      Define the number of channels in the file.

       -d [device], --device=[device]
	      Specify a different device to play the sound file to.

       -f [format], --format=[format]
	      Specify bit format of the sample. One of s, u, U, A, a, or g.

       -r [rate], --rate=[rate]
	      Specify the sample rate of the audio data (samples per second).

       -s [size], --size=[size]
	      Specify the width of each sample.  One of b, w, l, f, d, or D.

       -t [type], --type=[type]
	      Specify audio file format to use.  Useful if it can not be automatically determined.

       -v [volume], --volume=[volume]
	      Change the audio volume

       -x , --xinu
	      Reverse the byte order of the sample (only works with 16 and 32-bit data).

       -h, --help
	      Show summary of options.

       --version
	      Show version of play/rec.

       Description of effects are described in the
	      sox(1) man page.

SEE ALSO

	sox(1)
	soxexam(1)

AUTHOR

       This manual page was written by Guenter Geiger <geiger@iem.mhsg.ac.at>, for the Debian GNU/Linux system.

       Updates by Anonymous.

								 December 11, 2001							   play(1)
All times are GMT -4. The time now is 07:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy