PERL data - sorting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting PERL data - sorting
# 1  
Old 06-19-2008
PERL data - sorting

Hello,

I have a page where multiple fields and their values are displayed. But I am able to sort only a few fields. When I looked into the issue, it is seen that the for each row of info , an unique id is generated and id.txt is generated and saved. Only those fields which are inside that id.txt are capable of getting sorted.

Can someone help me to make more fields to be saved in that file?

Thanks
# 2  
Old 06-19-2008
Post some sample data and the code you are using to sort the data. Explain the data formating if necessary.
# 3  
Old 06-20-2008
In the html page, I have the format

Type id Status Open Title
Requirement 00325 In-progress 2008-06-18 Field updation status
Coding 00301 Closed 2008-05-23 Requirement analysis status

Stored files

cat data00325.txt
[info]
status: In-progress
open: 2008-06-18
title : Field updation status

cat data00301.txt
[info]
status: Closed
open: 2008-05-23
title : Requirement analysis status


As Type is not stored in data files, I believe we can't sort by that. I am able to sort by status/open/title. I am exploring how status field is getting into the data file and why not 'Type' field. I believe if that gets into the file, I can sort by that too.

As a beginner in perl, seeking your guidance.
# 4  
Old 06-20-2008
HTML files usually have some html markup code in them. But anyway, if you have a file like this:

Requirement 00325 In-progress 2008-06-18 Field updation status
Coding 00301 Closed 2008-05-23 Requirement analysis status

You would split the file using the split() function into an array and do whatever it is you need to do with the data.

Code:
open (FH, 'thefile.html') or die "$!";
while (<FH>){
   chomp;
   my @data = split(/\s/,$_,5);
   # now the data is split into five fields, for example:
   $data[0] = Requirement
   $data[1] = 00325
   $data[2] = In-progress
   $data[3] = 2008-06-18
   $data[4] = Field updation status
   # from here I have no idea what you need to do
}
close (FH);

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting the data with date

Hi, PFB the data: C_Random_130417 Java_Random_130518 Perl_Random_120519 Perl_Random_120528 so the values are ending with year,i.e.,130417 i want to sort the values with date. i want the output like this: Perl_Random_120519 Perl_Random_120528 C_Random_130417 Java_Random_130518 can... (5 Replies)
Discussion started by: arindam guha
5 Replies

2. Shell Programming and Scripting

HELP on Perl array / sorting - trying to convert Korn Shell Script to Perl

Hi all, Not sure if this should be in the programming forum, but I believe it will get more response under the Shell Programming and Scripting FORUM. Am trying to write a customized df script in Perl and need some help with regards to using arrays and file handlers. At the moment am... (3 Replies)
Discussion started by: newbie_01
3 Replies

3. 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

4. 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

5. Shell Programming and Scripting

Remove default data hash sorting in perl script?

Hi, I have a datahash with 'n' number of values in perl script. I am writing a xml file from the datahash. I am getting output with sorting(Field sorting). My question is that i don't want any default sorting.whatever i am inserting into datahash it should give same xml file. Any help? ... (0 Replies)
Discussion started by: solo123
0 Replies

6. 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

7. 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

8. 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

9. Shell Programming and Scripting

Sorting blocks of data

Hello all, Below is what I am trying to accomplish: I have a file that looks like this /* ----------------- xxxx.y_abcd_00000050 ----------------- */ jdghjghkla sadgsdags asdgsdgasd asdgsagasdg /* ----------------- xxxx.y_abcd_00000055 ----------------- */ sdgsdg sdgxcvzxcbv... (8 Replies)
Discussion started by: alfredo123
8 Replies
Login or Register to Ask a Question