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
# 8  
Old 05-14-2008
Hello era / unix gurus,

I tried the following:
sed -e "x;/^AAA/b" -e "/^BBB/b" -e d number.dat

It works. But I need to divert it to different files .How do I do it. Kindly assist if possible

Thanks and Regards,
Vinay
# 9  
Old 05-14-2008
Did you try the script I posted above? If so, what's wrong with it? It writes lines matching "^AAA" to AAA.dat and lines matching the regular expression "^BBB" to BBB.dat, is that not what you want?
# 10  
Old 05-14-2008
Hello era,

The script u had sent did not work.
Its giving an error
sed: command garbled: /^AAA/wAAA.dat/^BBB/wBBB.dat

That is why I tried
sed -e "x;/^AAA/b" -e "/^BBB/b" -e d number.dat
I am getting answer properly, but I dont know how to route it to different files.
# 11  
Old 05-14-2008
The script should be on two different lines. You could also try

Code:
sed -e '/^AAA/wAAA.dat' -e '/^BBB/wBBB.dat' number.dat

The sed w command takes a file name to write the line to.
# 12  
Old 05-14-2008
Hi era,
sed -e '/^AAA/w AAA.dat' -e '/^BBB/w BBB.dat' number.dat works..
Thanks a lot.
Can I specify the path where it should be stored:
sed -e '/^AAA/w /export/home/vinay/AAA1.dat' -e '/^BBB/w /export/home/vinay/BBB1.dat' a.dat
I hope there is some error

Also does sed provides a way to search specific fields, like the -f1 (1st field) option

Also does the sed -e '/^AAA/w AAA.dat' -e '/^BBB/w BBB.dat' number.dat traverses through the number.dat once or twice.

.. Kindly assist me if possible
Thanks and Regards,
Vinay

Last edited by Vinaykumar1; 05-14-2008 at 05:47 AM..
# 13  
Old 05-14-2008
sed uses regular expressions only, you can create a regex to look at the first field only with regex constructs; the ^ is already halfway there, as it forces the match to happen at beginning of line. Suppose the field separator is a vertical bar; then you can just add that after the string you want to search for, to anchor it properly.

Code:
sed -e '/^AAA|/w/export/home/vinay/AAA1.dat' -e '/^BBB|/w/export/home/vinay/BBB1.dat' a.dat

This finds "AAA" followed by vertical bar, but only if it is at beginning of line (because of the ^) and ditto for "BBB".

The vertical bar has special meaning to some regular expression engines, just like the ^ -- if you get erratic behavior (all lines matching all the time) then you need to backslash-quote it, like \|. It is unfortunate that there are different dialects of sed so that we can't know for sure whether or not this is an issue in your case.

Last edited by era; 05-14-2008 at 05:52 AM.. Reason: Separator is vertical bar, as per above
# 14  
Old 05-14-2008
Hello era / unix gurus,

I tried the above script but its giving me
sed: command garbled: /^AAA \|/w/export/home/cmohanku/vinay/AAA1.dat

"Also does the sed -e '/^AAA/w AAA.dat' -e '/^BBB/w BBB.dat' number.dat traverses through the number.dat once or twice."


Please help me if possible

Thanks and Regards,
Vinay
 
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