Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help Needed in arrangind data!

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help Needed in arrangind data!
# 1  
Old 06-21-2009
Error Help Needed in arrangind data!
Dear All,

Please view the below mentioned text and help me in arranging data in format like

DATE TIME Value (2nd-Feild)

e.g.

20-JUN-209 00:25:38 69.00
...........
...........
...........
...........

and so on till the file end.


Code:
20-JUN-2009 00:25:38, 195.20,  69.00,540,159,699,21,2020-JUN-2009 00:40:38, 197.40,  62.00,502,146,649,21,20
20-JUN-2009 00:55:39, 180.81,  73.00,482,138,620,21,2020-JUN-2009 01:10:39, 209.59,  88.00,451,128,580,21,2020-JUN-2009 01:25:39, 18
9.98,  69.00,411,117,529,21,2020-JUN-2009 01:40:40, 173.11,  69.00,376,106,483,21,2120-JUN-2009 01:55:40, 163.42,  69.00,347,106,454
,21,2020-JUN-2009 02:10:41, 159.32,  69.00,321,100,421,21,2020-JUN-2009 02:25:41, 154.32,  69.00,285,88,374,21,2020-JUN-2009 02:40:4
1, 142.03,  69.00,245,76,322,21,2120-JUN-2009 02:55:41, 137.63,  69.00,204,68,273,21,2120-JUN-2009 03:10:42, 129.13,  69.00,172,62,2
34,21,2120-JUN-2009 03:25:42, 108.44,  69.00,146,54,201,21,2120-JUN-2009 03:40:42, 115.74,  69.00,120,48,168,21,2120-JUN-2009 03:55:
42, 102.45,  69.00,99,43,142,21,2120-JUN-2009 04:10:43,  90.85,  69.00,87,41,128,21,2120-JUN-2009 04:25:43,  83.75,  69.00,69,34,104

Thankz in advanceSmilie
# 2  
Old 06-21-2009
where's your code?
# 3  
Old 06-21-2009
thts the output file being generated by script and i need to arrange data as mentioned previoulsy.

please advice any suitable coomand or code to sort this data as desiredSmilie
# 4  
Old 06-21-2009
what have you tried?
# 5  
Old 06-21-2009
well, there is an automated file generated by the system in a particular directory,

later i ftp through an automated script, after getting this file, the sample output i get was attached in my first post.

Now i want to sort this data as mentoned earlier.

This is bascially an script which is getting system SAR.

Hope this might help u.......Smilie
# 6  
Old 06-21-2009
you don't seem to get my message. What have you tried so far to solve your problem? where is your script?? if you don't have a script, start writing one!. you are introduced to shell scripting from previous posts...so i would expect you already read up on basic shell scripting.
# 7  
Old 06-21-2009
ok here is the script

Code:
#!/bin/sh
DATE=`date +%Y%m%d`
ftp -inv 192.168.0.130 <<END
quote user abcd
quote pass qwer
   bin
cd who_me0:[RECORDS]
lcd /tmp/SAR
prompt
mget filename
END
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

data integrity check needed

Hi friends I need copied 100gd of data to other Solaris server. Could anyone help me guiding appropriate way of checking data integrity at source and destination so can I delete the data at source location . How can print/check cksum of individual file in each folder and match it with... (7 Replies)
Discussion started by: hk_kamozalwar
7 Replies

2. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

3. Shell Programming and Scripting

Help needed to sort data

Hello All, Today i have been asking lots of question, hope to become good in scripting soon with all the wonderful advices i get. The question is i want to sort data a get uniq string from it. The code i am using to generate the output is:- check_sun() { for i in $SUN_PLATFORM do $ECHO... (0 Replies)
Discussion started by: asirohi
0 Replies

4. Shell Programming and Scripting

Help needed to stick on variable data to an output

Hi all, I need help now to stick the value inside $RHAT_PRODUCT and display that in every line in the output. What changes in the code can i do. Please suggest Thanks Adsi #!/bin/sh ECHO=/bin/echo FIND=/bin/find AWK=/bin/awk LS=/bin/ls GREP=/bin/grep ... (1 Reply)
Discussion started by: asirohi
1 Replies

5. Shell Programming and Scripting

Help needed with Sort and uniq data

Hi All, After Sorting directories and files i have got following output as below, now i only want the strings common in them, so the actual output should be as below in the bottom. How do i do that? Thanks -adsi File to be modified:- Common Components for ----> AA... (4 Replies)
Discussion started by: asirohi
4 Replies

6. UNIX and Linux Applications

help needed- data analysis-table-chart-2d plot software

Hi all, I posted the same message under 'Kaleidagraph like software for Ubuntu' thread. I guess there may not be many people familiar with Kaleidagraph. So I post my message under another subject name. I need a tool for Ubuntu 8.10, -which is quick and easy to learn and use (as I am... (1 Reply)
Discussion started by: apprentice
1 Replies

7. Shell Programming and Scripting

Script - Filter data - repeated loop - Help needed...

Dear Friend, I need a help for the below problem.. Can anyone suggest me to do... Input file data: rule { name=mainrule filt=pos loc { x=right + 660 y=top - 3100 } object_kind= DRAW ... (15 Replies)
Discussion started by: vasanth_vadalur
15 Replies

8. Shell Programming and Scripting

help needed .. Unable to write the data to new file after matching the pattern

Hi, i am pretty new to Unix environment ..... Can i get some help from any of you guyz on writing Unix script. my requirement is like reading a csv file, finding a specific pattern in the lines and repalce the string with new string and write it to another file. My file is file ABC123.dat... (3 Replies)
Discussion started by: prashant_jsw
3 Replies

9. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies
Login or Register to Ask a Question