Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk, string as record separator, transposing rows into columns
Top Forums Shell Programming and Scripting awk, string as record separator, transposing rows into columns Post 302513565 by spindoctor on Wednesday 13th of April 2011 03:09:22 PM
Old 04-13-2011
@Shell_Life:
The expected result is this (lines only separated at 2 of 26, 3 of 26, etc.:
1 of 26 Documents, Copyright 2010 etc, All Rights Reserved, The Age (Melbourne, Australia), November 27, 2010
2 of 26 Documents, Copyright 2010 etc, All Rights Reserved, The Age (Melbourne, Australia), November 27, 2010
3 of 26 Documents, Copyright 2010 etc, All Rights Reserved, The Age (Melbourne, Australia), November 27, 2010

@cgkmal, I don't think that will work. There are many different newspaper names.
If you look in the script that I'm using, I first grep the 5 lines from each line that matches "[0-9] Documents$", so that grabs all the text from the Document Number down to the date. But it produces it a file where all the information is in rows...

1 of 26 Documents
Copyright
All Rights reserved
NOvember 27, 2010.

So I'm trying to transpose. I don't think your solution will work because I've got other newspaper titles.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Rows to columns transposing and reformating.

----File attached. Input file =========== COL_1 <IP Add 1> COL_2 <Service1> COL_3 <ABCDEFG> COL_4 <IP ADD:PORT> COL_4 <IP ADD:PORT> COL_1 <IP Add 2> COL_2 <Service2> COL_2 <Service3> COL_2 <Service4> COL_3 <AAAABBB> COL_4 <IP ADD:PORT> COL_4 <IP ADD:PORT> COL_4 <IP... (27 Replies)
Discussion started by: bluethunder
27 Replies

2. Shell Programming and Scripting

Transposing columns with awk

I want a sweet simple time efficient awk script in online which gets output 001_r 0.0265185 0.0437049 0.0240642 0.0310264 0.0200482 0.0146746 0.0351344 0.0347856 0.036119 1.49 firstcoloumnvalue allvaluesof 'c' in one row 001_r : 002_r c: 0.0265185 N: 548 001_r : 007_r c:... (5 Replies)
Discussion started by: phoenix_nebula
5 Replies

3. Shell Programming and Scripting

Transposing rows into columns

I have a file like the one given below P1|V1|V2 P1|V1|V3 P1V1|V2 P2|V1|V4 P2|V2|V6 P2|V1|V4 I want it convert to P1|V1|V2|V2|V3 P2|V1|V4|V2|V6 2nd and 3rd column should be considered as together and so the tird row is duplicate Any ideas? (3 Replies)
Discussion started by: prasperl
3 Replies

4. Shell Programming and Scripting

Transposing Repeated Rows to Columns.

I have 1000s of these rows that I would like to transpose to columns. However I would like the transpose every 3 consecutive rows to columns like below, sorted by column 3 and provide a total for each occurrences. Finally I would like a grand total of column 3. 21|FE|41|0B 50\65\78 15... (2 Replies)
Discussion started by: ravzter
2 Replies

5. Shell Programming and Scripting

Help for a Perl newcomer! Transposing data from columns to rows

I have to create a Perl script which will transpose the data output from my experiment, from columns to rows, in order for me to analyse the data. I am a complete Perl novice so any help would be greatly appreciated. The data as it stands looks like this: Subject Condition Fp1 ... (12 Replies)
Discussion started by: Sarah_W
12 Replies

6. Shell Programming and Scripting

transposing columns into rows

Hi, I need to transpose columns of my files into rows and save it as individual files. sample contents of the file below. 0.9120 0.7782 0.6959 0.6904 0.6322 0.8068 0.9082 0.9290 0.7272 0.9870 0.7648 0.8053 0.8300 0.9520 0.8614 0.6734 0.7910 0.6413 0.7126 0.7364 0.8491 0.8868 0.7586 0.8949... (8 Replies)
Discussion started by: ida1215
8 Replies

7. Shell Programming and Scripting

Transposing rows and columns (pivoting) using shell scripting

Here is the contents of an input file. A,1,2,3,4 10,aaa,bbb,ccc,ddd 11,eee,fff,ggg,hhh 12,iii,jjj,lll,mmm 13,nnn,ooo,ppp I wanted the output to be A 10 1 aaa 10 2 bbb 10 3 ccc 10 4 ddd 11 1 eee 11 2 fff 11 3 ggg 11 4 hhh ..... and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies

8. Shell Programming and Scripting

Transposing rows to columns with multiple similar lines

Hi, I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:- ID 1A02_HUMAN AC P01892; O19619; P06338; P10313; P30444; P30445; P30446; P30514; AC Q29680; Q29837;... (2 Replies)
Discussion started by: redse171
2 Replies

9. Shell Programming and Scripting

Use string as Record separator in awk

Hello to all, Please some help on this. I have the file in format as below. How can I set the record separator as the string below in red "No. Time Source Destination Protocol Length Info" I've tried code below but it doesn't seem to... (6 Replies)
Discussion started by: cgkmal
6 Replies

10. Shell Programming and Scripting

Pivot Rows to Columns, with field separator

Hi All, I have a requirement to flatten data out, based on the value in COL_2. Our file is pipe delimited, however COL_2 contains a comma separated string, which we would like to pivot out from one row into multiple rows. Please see my example input data below: Input Data ... (4 Replies)
Discussion started by: RichZR
4 Replies

LEARN ABOUT SUSE

pdl::pptemplate

pptemplate(3)						User Contributed Perl Documentation					     pptemplate(3)

NAME

       pptemplate - script to generate Makefile.PL and PP file skeleton

SYNOPSIS

	       # generate Makefile.PL and mymodule.pd in CWD
	       pptemplate PDL::MyModule;

DESCRIPTION

       The pptemplate script is the easiest way to start a new module for PDL that contains PP code (see also PDL::PP). The usage is simply

	 pptemplate modulename;

       As a result pptemplate will generate a perl Makefile for the new module (Makefile.PL) that contains the minimal structure to generate a
       module from PP code and also a skeleton file for your new module.

       The file will be called mymod.pd if you called "pptemplate" as

	 pptemplate PDL::CleverAlgs::Mymod;

       I suppose you can work out the naming rule ";)". If not resort to experimentation or the source code.

       "pptemplate" will refuse to overwrite existing files of the same name to avoid accidents. Move them out of the way if you really want to
       scrap them.

   Options
       Currently there is only the "-i" option which switches "pptemplate" into the so called internal mode.  It should only be used when you are
       starting a new module within the main PDL tree that is supposed to be part of the PDL distribution and the normal PDL build process, e.g.

	  cd PDL/IO;
	  mkdir Mpthree; cd Mpthree;
	  pptemplate -i PDL::IO::Mpthree;

BUGS

       Maybe ";)".  Feedback and bug reports are welcome.

COPYRIGHT

       Copyright (c) 2001, Christian Soeller. All Rights Reserved.  This module is free software. It may be used, redistributed and/or modified
       under the same terms as PDL itself (see http://pdl.perl.org).

perl v5.12.1							    2010-07-05							     pptemplate(3)
All times are GMT -4. The time now is 06:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy