Sorting data and place them in different folders


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sorting data and place them in different folders
# 1  
Old 05-13-2008
Sorting data and place them in different folders

Hello Unix gurus,
I am new to Unix. I am working on some dummy project which involves unix scripting.

I have a query :

There is a file Number.dat which is of form say

AAA|123|4563|animal
AAA|1234|45634|animal2
BBB|123444|456312|bird
BBB|123445|456313|bird2

Here AAA,BBB are headers.
Now I want to sort Number.dat based on header and place them in different header.dat file.
How do I do that? I would be really greatful if some one helps me.


Thanks in advance
Vinay
# 2  
Old 05-13-2008
What have you done to attempt to solve this problem yourself?
Post your sample script, and we'll see how we can assist.

Regards
# 3  
Old 05-13-2008
using awk we can achive your solution.

using awk we can get the solution for your problem


if $1 ='AAA' we can redirect it into new file AAA.dat
and if $1 ='BBB' we can redirect it into new file BBB.dat


please use this way to get the solutions

Regards,
Siva.P
Bangalore
# 4  
Old 05-14-2008
Hello Franklin / Unix gurus,

My script is as follows:


#!/bin/ksh
sys=/export/home/vinay/Number.data
mod1=AAA
mod2=BBB

grep -h 'AAA' $sys > /export/home/vinay/AAA_$mod1.data
grep -h 'BBB' $sys > /export/home/vinay/BBB_$mod2.data


But I am not happy with the script since it has to traverse twice imto the Number.dat file


Also I some questions,

I want the process to use the Number.dat once rather than traversing twice.
Also, say if memory is full while script is running, then how should I handle it.
Kindly reply back if any one has a suggestion/script/solution

Thanks in advance.

Regards,
Vinay

Last edited by Vinaykumar1; 05-14-2008 at 02:18 AM..
# 5  
Old 05-14-2008
Both awk and sed have facilities for writing into multiple files as they read in a single pass down the file. psiva_arul is hinting in the same direction in the posting above.
# 6  
Old 05-14-2008
hello era /Unix gurus,
If you don't mind, can you assist in which fashion I can make use of sed into my script.

Thanks and Regards,
Vinay

Last edited by Vinaykumar1; 05-14-2008 at 02:43 AM..
# 7  
Old 05-14-2008
Googling is not an option?

Code:
sed -n '/^AAA/wAAA.dat
/^BBB/wBBB.dat' file

Notice that writing doesn't have any side effect (such as, for example, finish this line and fetch the next) so if you have patterns which overlap, you can get the same line written to multiple files (or need to write a slightly more complex script).
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying text file records, find data in one place in the record and print it elsewhere

Hello, I have some text data that is in the form of multi-line records. Each record ends with the string $$$$ and the next record starts on the next line. RDKit 2D 15 14 0 0 0 0 0 0 0 0999 V2000 5.4596 2.1267 0.0000 C 0 0 0 0 0 0 0 0 0 0 0 ... (5 Replies)
Discussion started by: LMHmedchem
5 Replies

2. Shell Programming and Scripting

How to merge variable data from another file into specific place?

Hello, I'm trying to create multiple commands using a variable input from another file but am not getting any successful results. Basically, file1.txt contains multiple lines with single words: <file1.txt> yellow blue black white I want to create multiple echo commands with these... (8 Replies)
Discussion started by: demmel
8 Replies

3. Shell Programming and Scripting

search data from text file in different folders

I am fairly new to unix scripting, the problem is i can understand the unix script. but i fail to write. I do not know where to start and how to end. I am sure this forum will help to achive my dream scriptings in unix. Thanks in adv for your help. Here I need.. I have list of columns in one... (2 Replies)
Discussion started by: dsnrhdy
2 Replies

4. Shell Programming and Scripting

Sorting the Data

My actual data looks like below i have given only format. i can't give exact data format of my requirement due to some reasons. I this set of data lines about 5000 I need to come up with information in below exact format of my data set : Line<space>Number1<space>"somedata":... (1 Reply)
Discussion started by: ckaramsetty
1 Replies

5. UNIX for Dummies Questions & Answers

Help with Data Sorting

Hi All, I have a long list made of 4 columns containing entries such as the following example: a b c d 0 0 0 0 1 2 1 2 2 5 3 4 3 8 4 6 4 10 9 8 5 15 8 10So the top row is the header and I need to arrange the data in a way as to... (11 Replies)
Discussion started by: pawannoel
11 Replies

6. Shell Programming and Scripting

sorting files or folders

I have the small script to arrange files of a descending way. ls -l |sort -r -k4 i wanted for example if I place -d one arranges only the folders or -a to arranges only the files. Cheers (7 Replies)
Discussion started by: krlos07
7 Replies

7. UNIX for Dummies Questions & Answers

Sorting data

Hello guys. I need help figuring this one out. It's probably really easy. Thanks in advance! I have a file say for example containing this: Rice Food Carrots Food Beans Food Plates Kitchen Fork Kitchen Knives Kitchen I need: Food Rice, Carrots, Beans Kitchen Plates, Fork,... (7 Replies)
Discussion started by: visuelz
7 Replies

8. Solaris

What is the best way to copy data from place to another place?

Dear Gurus, I need you to advice or suggestion about the best solution to copy data around 200-300G from serverA(location A) to serverB(location B). Normally, I will share folder and then copy but it takes too long time(about 2 days). Do you have any suggestion or which way should be... (9 Replies)
Discussion started by: unitipon
9 Replies

9. UNIX for Dummies Questions & Answers

Sorting data from a to z

Hi, Let's say I have these 3 columns; NGC1234 6 9 SL899 4 1 NGC1075 8 3 SL709 5 2 And I want to sort the data according to the first column (from a to z) like having them as: NGC1075 8 3 NGC1234 6 9 SL709 5 2 SL899 4 1 Can that be done... (2 Replies)
Discussion started by: cosmologist
2 Replies

10. UNIX for Dummies Questions & Answers

sorting data from who by IP

Hello. I have an RS/6000 running AIX 4 and I need to be able to see if there are any users that are logged on more than once from the same terminal so I can kick them off to make room for other terminals. 64 connections is the limit. Currently I am doing this: who | more and then manually... (11 Replies)
Discussion started by: raidzero
11 Replies
Login or Register to Ask a Question