03-10-2007
Please give a try on this...
key_field=$(awk -F" " '{ print $1;}' filename | uniq)
for each_key in $key_field;
do
awk -F" " -v ind=$each_key '{ if($1==ind) { for(i=2;i<=NF;i++) { s = s" "$i;}}} END { print ind s} ' filename;
done
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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... (8 Replies)
Discussion started by: merry susana
8 Replies
2. UNIX for Dummies Questions & Answers
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: (4 Replies)
Discussion started by: bobo
4 Replies
3. UNIX for Dummies Questions & Answers
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... (12 Replies)
Discussion started by: bobo
12 Replies
4. UNIX for Dummies Questions & Answers
10 2 1 2 3 4 5 6 7 8
20 3 2 1 3 2 9 8 2 1
Need the data to be arranged:
10 2 1 5
2 6
3 7
4 8
20 3 2 1
1 2
3 8
2 9
please help! (6 Replies)
Discussion started by: bobo
6 Replies
5. Shell Programming and Scripting
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... (7 Replies)
Discussion started by: Abhishek Ghose
7 Replies
6. Shell Programming and Scripting
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 (6 Replies)
Discussion started by: anushree.a
6 Replies
7. Shell Programming and Scripting
im trying to write a script that will put files with different extensions into their specified directories
In the directory are files of various types, i want to arrange the files on individual directories under their type. There are three distinct types of files: 1) Text documents - files with... (2 Replies)
Discussion started by: elginmulizwa
2 Replies
8. UNIX for Advanced & Expert Users
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 ... (1 Reply)
Discussion started by: Mapilo
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I do have question for un tar a file. I have several 'tar'ed files. For example: SRS.tar.bz2. I was trying to untar them in a linux server using the command:
tar xvjf SRS.tar.bz2
It worked perfectly. but when I open this file in my mac computer all the files are extracted into a... (7 Replies)
Discussion started by: Lucky Ali
7 Replies
10. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: kareena
2 Replies
LEARN ABOUT OPENSOLARIS
setcolor
setcolor(1F) FMLI Commands setcolor(1F)
NAME
setcolor - redefine or create a color
SYNOPSIS
setcolor color red_level green_level blue_level
DESCRIPTION
The setcolor command takes four arguments: color, which must be a string naming the color; and the arguments red_level, green_level, and
blue_level, which must be integer values defining, respectively, the intensity of the red, green, and blue components of color. Intensities
must be in the range of 0 to 1000. If you are redefining an existing color, you must use its current name (default color names are: black,
blue, green, cyan, red, magenta, yellow, and white). setcolor returns the color's name string.
EXAMPLES
Example 1 A sample output of setcolor command.
The following is an example of the arguments that setcolor takes:
`setcolor blue 100 24 300`
BUILT-IN FMLI
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
SunOS 5.11 5 Jul 1990 setcolor(1F)