Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to read different lines into column
Top Forums Shell Programming and Scripting How to read different lines into column Post 302410653 by durden_tyler on Tuesday 6th of April 2010 01:12:58 PM
Old 04-06-2010
Quote:
Originally Posted by tojzz
...
The input file is as follows:

Code:
Name:    test01
Name UID:     C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02
Shareable:             YES
 
HBA/SP Pairs:
  HBA UID                                          SP Name     SPPort
  -------                                          -------     ------ 
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP B         0
Host name:             test01.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP A         1
Host name:             test02.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP B         2
Host name:             test01.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP A         2
Host name:             test02.com
  20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60   SP A         0
Host name:             test01.com
  20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60   SP B         1
Host name:             test02.com
 
Primary/Secondary Pairs:
  Pri Number     Sec Number
  ----------     ----------
    8               7
    10              8
    9               9
    7               10
 
Shareable:             YES
 
Name:    test02
Name UID:     C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02
Shareable:             YES
 
HBA/SP Pairs:
  HBA UID                                          SP Name     SPPort
  -------                                          -------     ------ 
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP B         0
Host name:             test01.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP A         1
Host name:             test02.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP B         2
Host name:             test01.com
  20:00:00:1B:32:92:32:B6:21:00:00:1B:32:92:32:B6   SP A         2
Host name:             test02.com
  20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60   SP A         0
Host name:             test01.com
  20:00:00:1B:32:92:1D:60:21:00:00:1B:32:92:1D:60   SP B         1
Host name:             test02.com
 
Primary/Secondary Pairs:
  Pri Number     Sec Number
  ----------     ----------
    0               6
    2               1
    1               0
    4               3
    3               2
    6               5
    5               4
Shareable:             YES

What I want to get is like:

Name Name UID Host Name Pri Number Sec Number

...
What should the output look like, for the input file that you have posted ?
i.e. type in the expected output in your post.

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to read the column and print the values under that column

hi all:b:, how to read the column and print the values under that column ...?? file1 have something like this cat file1 ======= column1, column2,date,column3,column4..... 1, 23 , 12/02/2008,...... 2, 45, 14/05/2008,..... 3, 56, 16/03/2008,..... cat file2 =======... (6 Replies)
Discussion started by: gemini106
6 Replies

2. Shell Programming and Scripting

paste each 10 lines of single column to several column

Hi, I need to paste each 10 lines of single column to several columns. Please, can anyone tell me how to write in awk? Input File: 22 34 36 12 17 19 15 11 89 99 56 38 29 (4 Replies)
Discussion started by: nica
4 Replies

3. Shell Programming and Scripting

Read CSV column value based on column name

Hi All, I am newbie to Unix I ve got assignment to work in unix can you please help me in this regard There is a sample CSV file "Username", "Password" "John1", "Scot1" "John2", "Scot2" "John3", "Scot3" "John4", "Scot4" If i give the column name as Password and row number as 4 the... (3 Replies)
Discussion started by: JohnGG
3 Replies

4. Shell Programming and Scripting

Select lines in which column have value greater than some percent of total file lines

i have a file in following format 1 32 3 4 6 4 4 45 1 45 4 61 54 66 4 5 65 51 56 65 1 12 32 85 now here the total number of lines are 8(they vary each time) Now i want to select only those lines in which the values... (6 Replies)
Discussion started by: vaibhavkorde
6 Replies

5. UNIX for Dummies Questions & Answers

When reading a csv file, counter to read 20 lines and wait for minute then read next 20 till end

Hello All, i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file. Any inputs are appreciated ... (3 Replies)
Discussion started by: victor.s
3 Replies

6. Shell Programming and Scripting

Filtering lines for column elements based on corresponding counts in another column

Hi, I have a file like this ACC 2 2 21 aaa AC 443 3 22 aaa GCT 76 1 33 xxx TCG 34 2 33 aaa ACGT 33 1 22 ggg TTC 99 3 44 wee CCA 33 2 33 ggg AAC 1 3 55 ddd TTG 10 1 22 ddd TTGC 98 3 22 ddd GCT 23 1 21 sds GTC 23 4 32 sds ACGT 32 2 33 vvv CGT 11 2 33 eee CCC 87 2 44... (1 Reply)
Discussion started by: polsum
1 Replies

7. UNIX for Dummies Questions & Answers

Converting column to rows for every 3 lines in the column

Hi gurus! Please help me with this one. I have an file with the following contents: a b c d e f g h i j I would like to make to transform it to look like this as my output file: a,b,c d,e,f (4 Replies)
Discussion started by: kokoro
4 Replies

8. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

9. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

10. Shell Programming and Scripting

Read first column and count lines in second column using awk

Hello all, I would like to ask your help here: I've a huge file that has 2 columns. A part of it is: sorted.txt: kss23 rml.67lkj kss23 zhh.6gf kss23 nhd.09.fdd kss23 hp.767.88.89 fl67 nmdsfs.56.df.67 fl67 kk.fgf.98.56.n fl67 bgdgdfg.hjj.879.d fl66 kl..hfh.76.ghg fl66... (5 Replies)
Discussion started by: Padavan
5 Replies
All times are GMT -4. The time now is 05:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy