Data rearranging from rows to column Post: 302955291

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find different column numbers among rows in data

I want to find the different column numbers among rows in a file. For example: A001 a b c d e ... N A002 a b c d e ... N A003 a b c d e ... N+1 A004 a b c d e ... N A005 a b c d e ... N+2 : : For most of the lines I will have N columns (say 1000 rows) in each line except the line 3...

2. Shell Programming and Scripting

column data to rows every n line

Hi every one, I am trying to organise an input text file like: input 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 into an output as following: output file 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

3. Shell Programming and Scripting

Summing up rows data regarding 1st column

Dear all, I have one file like LABEL A B C D E F G H I J K L M N G02100 64651.3 25630.7 8225.21 51238 267324 268005 234001 52410.9 18598.2 10611 10754.7 122535 267170 36631.4 G02100 12030.3 8260.15 8569.91 ...

4. Shell Programming and Scripting

Counting and rearranging the rows

Hi, I have a file that I re-arranged using awk and unix commands to produce a file that looks like this: JOE JOE JOE JOE JOE BOB BOB HI HI HI I want to count how many of the same rows there are and print it on the second column while only maintaining the original name once. The...

5. Shell Programming and Scripting

Transpose Column of Data to Rows

I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows: NAME=BOB ADDRESS=COLORADO PET=CAT NAME=SUSAN ADDRESS=TEXAS PET=BIRD NAME=TOM ADDRESS=UTAH PET=DOG I would...

6. Shell Programming and Scripting

[Solved] Compare column data in all the rows

Hi.. In the below sorted input file.. I am comparing the first 3 columns of data one by one row and it is a pipeline delimitter file.. AA|BB|CC|line1 AA|BB|CC|ine4 AA|BB|CC|line2 BB|CC|DD|line3 BB|CC|DD|line5 If first 3 columns of data matches with any record in the file the...

7. Shell Programming and Scripting

Convert Column data values to rows

Hi all , I have a file with the below content Header Section employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Data section ...

8. Shell Programming and Scripting

How to separate rows of data into another column?

I have data such as below where the value in second field is the same as that in the row after. 123456,22222,John,0,xyz 234567,22222,John1,1,cde 43212,3333,Jean,3,pip 84324,3333,Abel,2,cat I'd like to rearrange the output like below to put such records beside each other and separated with...

9. UNIX for Beginners Questions & Answers

Rearranging the column

I have a text file like this, I would like to rearrange the first column (Name) according to the third column(percentage)in descending order. I mean methionine with the highest percentage should be the first one to appear under the name column. But I also want to exclude the headers from this...

10. UNIX for Beginners Questions & Answers

How to transpose pieces of data in a column to multiple rows?

Hello Everyone, I am very new to the world of regular expressions. I am trying to use grep/sed for the following: Input file is something like this and there are multiple such files: abc 1 2 3 4 5 ***END*** abc 6 7 8 9 ***END*** abc 10

LEARN ABOUT DEBIAN

sysstat

SYSSTAT(5)							Linux User's Manual							SYSSTAT(5)

NAME

       sysstat - sysstat configuration file.

DESCRIPTION

       This  file is read by sa1(8) and sa2(8) shell scripts from the sysstat's set of tools.  It consists of a sequence of shell variable assign-
       ments used to configure sysstat logging.  The variables and their meanings are:

       HISTORY
	      The number of days during which a daily data file or a report should be kept. Data files or reports older than this number  of  days
	      will be removed by the sa2(8) shell script.

       COMPRESSAFTER
	      Number of days after which daily data files are to be compressed, either by gzip or bzip2.

       SADC_OPTIONS
	      Options  that  should be passed to sadc(8).  With these options (see sadc(8) manual page), you can select some additional data which
	      are going to be saved in daily data files.  These options are used only when a new data file is created. They will be  ignored  with
	      an already existing one.

FILES

       /etc/sysstat/sysstat

AUTHOR

       Sebastien Godard (sysstat <at> orange.fr)

SEE ALSO

       sadc(8), sa1(8), sa2(8)

       http://pagesperso-orange.fr/sebastien.godard/

Linux								  SEPTEMBER 2010							SYSSTAT(5)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find different column numbers among rows in data

Discussion started by: AMBER

2. Shell Programming and Scripting

column data to rows every n line

Discussion started by: nxp

3. Shell Programming and Scripting

Summing up rows data regarding 1st column

Discussion started by: AAWT

4. Shell Programming and Scripting

Counting and rearranging the rows

Discussion started by: phil_heath