Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK swapping fields on different lines
Top Forums Shell Programming and Scripting AWK swapping fields on different lines Post 302624433 by Klashxx on Monday 16th of April 2012 09:00:21 AM
Old 04-16-2012
If you want to try perl:
Code:
perl -lane 'if ( /^\s*(\w+)\s+\w+\s+(\d\d:\d\d).*/) {$L1=$_;$name=$1;next}
            if ($L1 && $name ne "" ){
                  s/^\s*(\w+\s)(.*)(\s+has.*)/$1$name$3/;$surn=$2;
                  $L1 =~ s/^(\s*)(\w+)(\s+.*)/$1$surn$3/;
                  print $L1."\n".  $_;undef $L1;undef $name;
             }else {print $_}' infile

Code:
ENTRANT LIST
 
Name         Entry Type    Fastest Time
--------------------------------------------
Mr. Smith         Cyclist          10:59        #(newline here)
Cyclist Andrew has a great track record....

******************************
Mr. Jones             Runner          45:12
Runner Chris has been an avid runner for....
******************************

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Swapping lines beginning with certain words using sed/awk

I have a large file which reads like this: fixed-address 192.168.6.6 { hardware ethernet 00:22:64:5b:db:b1; host X; } fixed-address 192.168.6.7 { hardware ethernet 00:22:64:5b:db:b3; host Y; } fixed-address 192.168.6.8 { hardware ethernet 00:22:64:5b:db:b4; host A; }... (4 Replies)
Discussion started by: ksk
4 Replies

2. Shell Programming and Scripting

Swapping of fields in a file

Hi I have afile with 15fields,say f1,f2....f15 delimited on comma. How can i swap the f1,f15 fields using unix shell commands or any script? Thanks (3 Replies)
Discussion started by: ksailesh
3 Replies

3. Shell Programming and Scripting

How to (n)awk lines of CSV with certain number of fields?

I have a CSV file with a variable number of fields per record. How do I print lines of a certain number of fields only? Several permutations of the following (including the use of escape characters) have failed to retrieve the line I'm after (1,2,3,4)... $ cat myfile 1,2,3,4 1,2,3 $ # Print... (1 Reply)
Discussion started by: cs03dmj
1 Replies

4. Homework & Coursework Questions

Swapping Fields with Sed

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: The assignment is to convert a text table to csv format. I've got the cleaning up done, but I need to swap two... (0 Replies)
Discussion started by: VoiceInADesert
0 Replies

5. Shell Programming and Scripting

awk - use fields from subsequent lines

I've run into a problem getting exactly what I want out of awk - some folks may recognize this as an output from Amazon's ec2-describe-instances: Given the following: INSTANCE i-4960f321 BLOCKDEVICE Line2Var2 TAG instance i-4960f321 Name web1 TAG instance i-4960f321... (2 Replies)
Discussion started by: colinjohnson
2 Replies

6. Shell Programming and Scripting

Swapping of fields in file

Hi Friends , I have file1.txt 1|b|46|123|47673|348738 2|c|63|124|7346|4783 3|y|45|125|5555|78789 output should swap the 4th field to the first field. output 123|1|b|46|47673|348738 124|2|c|63|7346|4783 125|3|y|45|5555|78789 (3 Replies)
Discussion started by: i150371485
3 Replies

7. Shell Programming and Scripting

select lines with certain values on certain fields with awk

I need a awk command to select from a log-file only the lines that have on the 2nd field (considering "|" separator) one of the values 10.216.22.XX or 10.216.22.YY or 10.216.22.ZZ and on the 4th field only values that contain strictly digits. I want the command to work parsing the file only once (I... (2 Replies)
Discussion started by: black_fender
2 Replies

8. Shell Programming and Scripting

Swapping fields

Hallo Team, This is the command that i am running : grep ",Call Forward Not Reachable" *2013* this is the output that i am getting (i did a head -10 but the files can be more than 1000) ... (8 Replies)
Discussion started by: kekanap
8 Replies

9. Shell Programming and Scripting

Swapping/replacing fields

Hallo Team, I would like to replace filed 4 and 7 with filed 39 how can i achieve this ? -bash-3.2$ cat dip1.csv| cut -f4,7,24,36,39 -d","|sort -u +27113996891,+27113996891,196.35.130.52,828854047,+27873500077 +27116452690,+27825702918,10.0.109.13:5060,+27116452690,+27116452690... (2 Replies)
Discussion started by: kekanap
2 Replies

10. Shell Programming and Scripting

awk to combine lines if fields match in lines

In the awk below, what I am attempting to do is check each line in the tab-delimeted input, which has ~20 lines in it, for a keyword SVTYPE=Fusion. If the keyword is found I am splitting $3 using the . (dot) and reading the portion before and after the dot in an array a. If it does have that... (12 Replies)
Discussion started by: cmccabe
12 Replies

LEARN ABOUT DEBIAN

pspp-dump-sav

pspp-dump-sav(1)						    PSPP Manual 						  pspp-dump-sav(1)

NAME

       pspp-dump-sav - dissect SPSS system file

SYNOPSIS

       pspp-dump-sav [-d | --data[=maxcases]] file...
       pspp-dump-sav --help | -h
       pspp-dump-sav --version | -v

DESCRIPTION

       The  pspp-dump-sav program reads each SPSS system file file and prints its contents.  The output format is useful for debugging system file
       readers and writers and for discovering how to interpret unknown or poorly understood records.  End users may find the  output  useful  for
       providing the PSPP developers information about system files that PSPP does not accurately read.

OPTIONS

       -d[maxcases]
       --data[=maxcases]
	      By  default, pspp-dump-sav does not print any of the data in a system file, only the file headers.  Specify this option to print the
	      data as well.  If maxcases is specified, then it limits the number of cases printed.

       -h
       --help Prints a usage message on stdout and exits.

       -v
       --version
	      Prints version information on stdout and exits.

BUGS

       Some errors that prevent files from being interpreted successfully cause pspp-dump-sav to exit without reading any additional  files  given
       on the command line.

AUTHORS

       Ben Pfaff and John Darrington.

SEE ALSO

       pspp(1), psppire(1).

PSPP
								   January 2012 						  pspp-dump-sav(1)
All times are GMT -4. The time now is 02:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy