Data arrangement Post: 302089617

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Data arrangement Post 302089617 by tayyabq8 on Wednesday 20th of September 2006 02:15:37 AM

09-20-2006

Forum Advisor

First of all it sounds like a homework.

Secondly your input is not clear, you should post at least 5 lines of your input file and their required output to get the exact logic of what you want, as per your given 2 lines what I understand is that, if line no. is odd then take frist 3 columns, leave next 3 columns and print a single column then print one incremented column (4th col ) and print next column after leaving 3 columns, if line no. is even then reverse the order, take first 3 cols and last column, then take the 4th column and 2nd last, then 5th and 3rd last and so on.

Here is the code as per above logic:

Code:

#! /bin/ksh
cnt=1
while read a b c d e f g h i j; do
if [[ $cnt%2 -eq 1 ]]; then
        echo $a $b $c $g
        echo $d $h
        echo $e $i
        echo $f $j
else
        echo $a $b $c $j
        echo $d $i
        echo $e $h
        echo $f $g
fi
(( cnt=cnt+1 ))
done < inputfile

Which will yeild your desired output:

Code:

admin@unix1:/home/admin$./test.sh
10 2 1 5
2 6
3 7
4 8
20 3 2 1
1 2
3 8
2 9

Regards,
Tayyab

Last edited by tayyabq8; 09-20-2006 at 03:37 AM..

tayyabq8

View Public Profile for tayyabq8

Find all posts by tayyabq8

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Text file arrangement

Dear UNIX experts: Hi, I have a text file which the contents are arranged vertically down, line by line. How do use a loop (I think) to make it arrange in vertical arrangement with a tab delimitated and write to a new file? Eg: of source file Hello World Good-day Thanks Welcome The...

2. UNIX for Dummies Questions & Answers

Data arrangement

I have these following data: Home Tom Member List 100 Yes 200 No Home Tom Member List 1 No 2 Yes Home Tome Member List 3 No 400 Yes I want my data to be consistants like this:

3. UNIX for Dummies Questions & Answers

Cell arrangement

I have a data file with hundreds of lines: I want to place a YES right below the line that say mydata....can someone please help! on the left is my the original data on the right the data format need to be: left > Right mydata > mydata yes > yesno > no mydata > mydata...

4. UNIX for Dummies Questions & Answers

Help on file arrangement

Can anyone help me on this. I have a file that looks like this: color red green blue color pink yellow number one two gender male gender female The output would look like this: color red green blue pink yellow number one two gender male female I have over 5000 rows and i dont want...

5. Shell Programming and Scripting

sorting/arrangement problem

Hi, I have the following 'sorting' problem. Given the input file: a:b:c:12:x:k s:m:d:8:z:m a:b:c:1:x:k p:q:r:23:y:m a:b:c:3:x:k p:q:r:1:y:m the output I expect is: a:b:c:1:x:k p:q:r:1:y:m s:m:d:8:z:m What happened here is I grouped together lines having the same values for...

6. Shell Programming and Scripting

Re-arrangement of data

Dear Frineds, I have a flat file as follows ABCD ABDCWQE POIERAS ADSGASGFG GHJKFHD XBDFGHFGDH POIU IJPFG AFGJFPGOU A;DGUPGU SFSDFDSDFHDSF SDFGHSFDH I want this column to be converted into row like follows ABCD, ABDCWQE, POIERAS, ADSGASGFG, GHJKFHD, XBDFGHFGDH

7. Shell Programming and Scripting

Help to data re-arrangement problem

Input file <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\ <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\ <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\

8. Shell Programming and Scripting

Help with data re-arrangement problem facing

Input file: <symbol>Q9Y8G1</symbol> <name>Q9Y8G1_EMENI</name> <symbol>Q6V953</symbol> <symbol>Q5B8K1</symbol> <name>Q6V953_EMENI</name> <symbol>G1A416</symbol> <name>G1A416_9FUNG</name> <symbol>D4N894</symbol> <name>D4N894_PLEER</name> <symbol>B0FFU4</symbol>...

9. UNIX for Advanced & Expert Users

Data re-arrangement

Hi I have a huge problem to solve ASAP. Can someone please help!!! My format is arranged in this format: It has three columns. LOGIN ALIAS REC_ID A BB1 0 A ...

10. Shell Programming and Scripting

Retreive data with arrangement

Hi all I have following part of a big file TTDS00002 Synonyms M1 receptor TTDS00002 Disease Alzheimer's disease TTDS00002 Disease Bronchospasm (histamine induced) TTDS00002 Disease Cognitive deficits TTDS00002 Disease Schizophrenia TTDS00002 Function The muscarinic acetylcholine...

LEARN ABOUT SUNOS

print

print(1)							   User Commands							  print(1)

NAME

       print - shell built-in function to output characters to the screen or window

SYNOPSIS

   ksh
       print [ -Rnprsu [n]] [arg...]

DESCRIPTION

   ksh
       The shell output mechanism. With no flags or with flag - or -, the arguments are printed on standard output as described by echo(1).

OPTIONS

       The following options are supported:

       -n	       suppresses new-line from being added to the output.

       -R

       -r	       (raw  mode) ignore the escape conventions of echo. The -R option will print all subsequent arguments and options other than
		       -n.

       -p	       causes the arguments to be written onto the pipe of the process spawned with |& instead of standard output.

       -s	       causes the arguments to be written onto the history file instead of standard output.

       -u [ n ]        flag can be used to specify a one digit file descriptor unit number n on which the output will be placed. The default is 1.

EXIT STATUS

       The following exit values are returned:

       0	Successful operation.

       >0	Output file is not open for writing.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       echo(1), ksh(1), attributes(5)

SunOS 5.10							    15 Apr 1994 							  print(1)