Visit Our UNIX and Linux User Community


Singled line records


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Singled line records
# 1  
Old 11-06-2009
CPU & Memory Singled line records

Hi, Smilie
Im new on this Linux groups and like to learn more,
Right now, Im working on a project (personal) and have a question fallowing problem
Im making a bash script to read many files and extract some fields and separate them according certain criteria, let say a have a big file with records like these
210,linux
211,linux
220,windows
230, solaris
240, linux
250,ubuntu
Now I made an awk process to make 4 different files:
Linux.txt
210,linux
211,linux
212, linux ....219
Windows.txt
220,windows...220
Solaris.txt
230.solaris...239
Ubuntu.txt
250,ubuntu...259
Here is where the fun begin, I already remove field 2 from each file, but can not make all records on a singled line, I need them all like look this Smilie
Linux.txt
210,211,212,...219
Windows.txt
220...229
Solaris.txt
230,...230
Ubuntu.txt
250,...259

Any help would be appreciated. Smilie

Zopilota
# 2  
Old 11-06-2009
Looks like homework, what kind of project is this?

Can you show us what you have attempted so far?
# 3  
Old 11-06-2009
Hi,

Hope it was a homework. Smilie

This is what I have so far.

Code:
while read line ;do
    grep $line $fileTre | awk 'BEGIN {FS = ","} ; {print $59}' >> $line'_'$fileFor
done < $fileTwo

With this I open a file $fileTwo for Reading and made a loop
Get $line value whish is normali a name (let say linux in first place)
from $fileTree and extract only field $59 (210, 211…219) and make a new file $line_$fileFor wich would be linux_fileFor for example.

Last edited by Franklin52; 11-06-2009 at 05:39 PM.. Reason: Please use code tags!!
# 4  
Old 11-06-2009
Ok, I hope I'm wrong.

Code:
awk -F, '{a[$2]=a[$2]?a[$2]FS$1:$1}END{for(i in a){print a[i] > i ".txt"}}' file

If this is new for you, you can have a read of The GNU Awk User's Guide.
# 5  
Old 11-06-2009
Thank you very much, it realy works.

Smilie

Zopilota

Previous Thread | Next Thread
Test Your Knowledge in Computers #649
Difficulty: Easy
aterm is an rxvt based terminal emulator developed for Afterstep.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creating duplicate records from a single line

Hi All, I would like to create a 1 million duplicate records from a single fixed length row. Is there a simple way to create this quickly in unix. I am using korn shell on the AIX OS. For ex, 100234 XHYSDDS SDSD OUPUT (1 million rows) 100234 XHYSDDS SDSD . . . 100234 XHYSDDS SDSD... (5 Replies)
Discussion started by: saratha14
5 Replies

2. Shell Programming and Scripting

Need the line number of failed records

Hi awk Gurus, I have file as below : file1.txt 7000,2,1,6 7001,2,1,7 7002,2,1,6 7003,1,2,1 file2.txt 7000,john,2,0,0,1,6 7000,john,2,0,0,1,7 7000,john,2,0,0,1,8 7000,john,2,0,0,1,9 7001,elen,2,0,0,1,7 7002,sami,2,0,0,1,6 7003,mike,1,0,0,2,1 (13 Replies)
Discussion started by: arunshankar.c
13 Replies

3. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

4. HP-UX

Utmpd(1M) can't handle records with same line but different ids

For ddfa(7), telnetd(1M) needs to create user accounting database records with the same line (representing the remote side) but different ids (representing the pty that comes to be used for the connection), like line "telnet/ss10" with first id "tb" and then id "tf". Utmpd(1M) cannot handle... (1 Reply)
Discussion started by: madhurtripathi
1 Replies

5. Shell Programming and Scripting

Help to Add and Remove Records only from first line/last line

Hi, I need help with a maybe total simple issue but somehow I am not getting it. I am not able to etablish a sed or awk command which is adding to the first line in a text and removing only from the last line the ",". The file is looking like follow: TABLE1, TABLE2, . . . TABLE99,... (4 Replies)
Discussion started by: enjoy
4 Replies

6. Shell Programming and Scripting

Capturing multi-line records containing known value?

Some records in a file look like this, with any number of lines between start and end flags: /Start Some stuff Banana 1 Some more stuff End/ /Start Some stuff End/ /Start Some stuff Some more stuff Banana 2 End/ ...how would I process this file to find records containing the... (8 Replies)
Discussion started by: cs03dmj
8 Replies

7. Shell Programming and Scripting

how to delete records with the given line numbers

I have a file which has about 10000 records and I need to delete about 50 records from the file. I know line numbers and am using sed '134,1357,......d' filename > new file. It does not seem to be working. Please Advice (5 Replies)
Discussion started by: mad_man12
5 Replies

8. Shell Programming and Scripting

records in a line

Hi I have a file "sample.txt" -------------------- 1 2 3 4 5 6 7 --------------------------- i want out like this --------------------------- 1,2,3,4,5,6,7 --------------------------- please provide script, (7 Replies)
Discussion started by: theshashi
7 Replies

9. Shell Programming and Scripting

Change a Char Multiple line records

Hi All i have a file that is to big for vi and is a multiple line record 3999||20090127163547796|196.46.162.250|1028|196.207.40.112|2152|00:0C:31:BB:25:5 4|00:00:0C:07:AC:06|655016000575511|05||3C65|0D029C1D|||00644B5A|||||||||||inter... (5 Replies)
Discussion started by: gseptember
5 Replies

10. UNIX for Advanced & Expert Users

delete records using line number(NR)

Hai I have a flat file which contains more than 6 crore lines or records. I want to delete only one line, using line number. For example I want to delete 414556 th line . How to do this using sed or awk command. thanks (3 Replies)
Discussion started by: tkbharani
3 Replies

Featured Tech Videos