Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to read different lines into column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to read different lines into column
# 8  
Old 04-10-2010
The host column should include test01.com/test02.com
Ygemici,

The column of Host Name should be test01.com/test02.com.

In addition, is that possible to use AWK script ?

Code:
Name   Name UID                                        Host Name  Pri Number    Sec Number
------ ----------------------------------------------- ---------- ----------    ----------
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     8               7
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com     10              8
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     9               9
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com     7               10
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     0               6
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com     2               1
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     1               0
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com     4               3
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     3               2
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com     6               5
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com     5               4
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test02.com

# 9  
Old 04-10-2010
MySQL
I update script (My awk is doesnt enough for do Smilie )

Code:
sed -e 's/\(Name:\)  *\(.*\)/\1\n--------\n\2\n/g' -e 's/\(Name UID:\)  *\(.*\)/\1\n------------------------------------------------\n\2\n/g' firs > firs2 
sed -e 's/\(Host name:\)  *\(.*\)/\1\n-------------\n\2\n/g' firs2 > firs3 sed -n '/[^[0-9][0-9]*[0-9][0-9]* ]*/p' firs3 > prinumber 
 
sed -n '/[test][0-9]*.com*/p' firs3 |sed -e 'N;s/\n/\//' -e 's/.*/&\n&/'  > hostname #changed
 
sed -n '/[test][0-9]*$/p' firs3 > namefirst 
sed -e '1,1s/\(.*\)/\1\n\1\n\1\n\1/g' -e '2,2s/\(.*\)/\1\n\1\n\1\n\1\n\1\n\1\n\1\n\1/g' namefirst > namelist 
sed -n '/[A-Z][A-Z]*[:digit:][:digit:]*/p' firs3 | sed '/^Name/d' | sed -e '1,1s/\(.*\)/\1\n\1\n\1\n\1/g' -e '2,2s/\(.*\)/\1\n\1\n\1\n\1\n\1\n\1\n
\1\n\1/g' > nameuid 
sed -e '1i Name' -e '1i ------' namelist > namelist1
sed -e '1i Name UID' -e '1i -----------------------------------------------' nameuid > nameuid1
 
sed -e '1i Host Name' -e '1i ---------------------' hostname > hostname1 #changed
 
sed -e '1i Pri Number\ Sec Number' -e '1i ----------\ ----------' -e 's/              /         /g' prinumber > prinumber1 #changed
paste -d " " namelist1 nameuid1 hostname1 prinumber1 | sed '1,1s/\(Name\) \(Name UID\) \(Host Name\) \(Pri Number\) \(Sec Number\).*/\1   \2\t\t\t\t\t       \3\t     \4\t\5/' #changed
 
Name   Name UID                                        Host Name             Pri Number Sec Number
------ ----------------------------------------------- --------------------- ---------- ----------
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     8          7
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     10         8
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     9          9
test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     7          10
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     0          6
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     2          1
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     1          0
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     4          3
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     3          2
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     6          5
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     5          4
test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com

# 10  
Old 04-10-2010
ygemici
Seems very complicated using sed. anyway, thanks so much ! Smilie

If possible, could anyone help based on AWK ?



Code:
 Code:
sed -e 's/\(Name:\)  *\(.*\)/\1\n--------\n\2\n/g' -e 's/\(Name UID:\)  *\(.*\)/\1\n------------------------------------------------\n\2\n/g' firs > firs2 sed -e 's/\(Host name:\)  *\(.*\)/\1\n-------------\n\2\n/g' firs2 > firs3 sed -n '/[^[0-9][0-9]*[0-9][0-9]* ]*/p' firs3 > prinumber  sed -n '/[test][0-9]*.com*/p' firs3 |sed -e 'N;s/\n/\//' -e 's/.*/&\n&/'  > hostname #changed sed -n '/[test][0-9]*$/p' firs3 > namefirst sed -e '1,1s/\(.*\)/\1\n\1\n\1\n\1/g' -e '2,2s/\(.*\)/\1\n\1\n\1\n\1\n\1\n\1\n\1\n\1/g' namefirst > namelist sed -n '/[A-Z][A-Z]*[:digit:][:digit:]*/p' firs3 | sed '/^Name/d' | sed -e '1,1s/\(.*\)/\1\n\1\n\1\n\1/g' -e '2,2s/\(.*\)/\1\n\1\n\1\n\1\n\1\n\1\n\1\n\1/g' > nameuid sed -e '1i Name' -e '1i ------' namelist > namelist1sed -e '1i Name UID' -e '1i -----------------------------------------------' nameuid > nameuid1 sed -e '1i Host Name' -e '1i ---------------------' hostname > hostname1 #changed sed -e '1i Pri Number\ Sec Number' -e '1i ----------\ ----------' -e 's/              /         /g' prinumber > prinumber1 #changedpaste -d " " namelist1 nameuid1 hostname1 prinumber1 | sed '1,1s/\(Name\) \(Name UID\) \(Host Name\) \(Pri Number\) \(Sec Number\).*/\1   \2\t\t\t\t\t       \3\t     \4\t\5/' #changed Name   Name UID                                        Host Name             Pri Number Sec Number------ ----------------------------------------------- --------------------- ---------- ----------test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     8          7test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     10         8test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     9          9test01 C7:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     7          10test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     0          6test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     2          1test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     1          0test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     4          3test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     3          2test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     6          5test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com     5          4test02 C4:9D:79:52:2A:3F:DF:11:A8:64:00:60:16:36:04:02 test01.com/test02.com
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question