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 302411946 by ygemici on Saturday 10th of April 2010 07:49:31 AM
Old 04-10-2010
MySQL
if you want sed script (but this method difficult and tiring)

Code:
sed -e '/^  20/d' -e '/^Primary/d' -e '/^ *HBA/d' -e '/^Shareable/d' -e '/^  -/d' -e '/^$/d'  file > firs 
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]*$/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
sed -e '1i Pri Number\tSec Number' -e '1i ----------\t----------' prinumber > prinumber1 
paste -d " " namelist1 nameuid1 hostname1 prinumber1 | sed '1,1s/\(Name\) \(Name UID\) \(Host Name\) \(Pri Number\)\t\(Sec Number\).*/\1   \2\t\t\t\t\t       \3  \4\t\5/'

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

 

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

LEARN ABOUT DEBIAN

fixnt

fixnt(1)							      Debian								  fixnt(1)

NAME

       fixnt - Filter for the Windows NT postscript printer driver.

SYNOPSIS

       fixnt < BADFILE.ps > GOODFILE.ps

DESCRIPTION

       The  Windows  NT  postscript  driver has a tendency to make broken postscript files, that are incompatible with psutils.  fixnt is a filter
       that fixes these problems, allowing the use of psnup(1).

       The filter takes the broken postscript file on stdin, and outputs a fixed postscript file on stdout.  It has no other form  for	invocation
       and takes no options on the command-line.

OPTIONS

       fixnt  takes no options.

BUGS

       fixnt does not check for NTPSOct94.  For a workaround, use a sed(1) command to replace 'NTPSOct94' with 'NTPSOct95', like so:
	      sed 's/NTPSOct94/NTPSOct95/g'
       This is particularly important for Windows NT 3.5 users.

AUTHOR

       fixnt   was   written   by   Holger   Bauer   <Holger.Bauer@topmail.de>,  Michael  Rath	<rath@itsm.uni-stuttgart.de>,  and  Akim  Demaille
       <demaille@inf.enst.fr>.

REPORTING BUGS

       Report bugs to the Authors, but avoid sending large postscript files.

       Patches are always welcome; send to <bauer@itsm.uni-stuttgart.de>.

SEE ALSO

       psnup(1), sed(1)

a2ps								   February 2003							  fixnt(1)
All times are GMT -4. The time now is 06:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy