Query


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Query
# 1  
Old 06-18-2009
Query

hi
i am producing txt outputs of archives created by our tsm software.
problem is some of these files are too large to open in excel so i can despatch.
here is a example of the output

TAG_460 /prod_bak 7 FILE /ARCHIVE/Whistles- 14182-001.tif 169771323 2009-05-19 root Archive Date: DEFAULT 17:02:44.000000 05/19/2009
TAG_460 /prod 7 FILE /ARCHIVE/Whistles- 14212-001.tif 169771325 2009-05-19 root Archive Date: DEFAULT 17:02:47.000000 05/19/2009
TAG_460 /cmd 7 FILE /ARCHIVE/Whistles- 14290-001.tif 169771327 2009-05-19 root Archive Date: DEFAULT

what i want to do is extract from the output the files that have been generated from one of the fields eg prod/cmd/prod_bak then out put these as seperate files so i can filter better
thanks
Treds
# 2  
Old 06-18-2009
I am not able to understand how I should help you? Please provide some details
# 3  
Old 06-18-2009
rakeshawasthi
i am wondering if there is a way of extarcting the info from the file using awk or some other unix querey from a txt file which is tab delimited
thanks
Treds
# 4  
Old 06-18-2009
check out the man pages of cut , awk,sed to delimite tab .
if you can post exact code and desired out put it will help
# 5  
Old 06-18-2009
Excel (2007) can take only 1 million raw's so if you have more than 1 million raw's you can split them by using the command

Code:
split -(put num. of raws you want in new file) file.txt.

BR
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

2. UNIX for Dummies Questions & Answers

Query

Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk... (0 Replies)
Discussion started by: abhi_n123
0 Replies

3. Shell Programming and Scripting

want to query : YES or NO

hi i want to make script. where i want to query from the user yes or no exp: do you want to proceed : y for yes n for NO. how this is possible in unix (3 Replies)
Discussion started by: dodasajan
3 Replies

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

5. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

6. UNIX for Dummies Questions & Answers

Need Help on query

I just started to learn unix - need help to write a script to query a logfile and produce the results that contains a specific word "alarm" for a period from X day to Y day. I really have no idea how to begin - :( please help... ____________________________________________________ #... (1 Reply)
Discussion started by: snipfer
1 Replies

7. Shell Programming and Scripting

query.....

hi friends i want to know details of `exec` exact use of this command ..... actually i went through the man page but i didn`t get the satisfactory ...conclusion.... thaks in advance.... (1 Reply)
Discussion started by: newson
1 Replies

8. Shell Programming and Scripting

query

I have converted data written on excel sheet in unix through shell & perl prg now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this: hfgg|tytt| but I want like... (2 Replies)
Discussion started by: akash
2 Replies

9. UNIX for Dummies Questions & Answers

query

hi, how can i do the following..... i have file containing followig a k 10000 b c 200000 d e 50 a j 40 how can i list all rows containg last value more than 1000? and how can i find number of blank rows in the file? THANKS! regards vivek (2 Replies)
Discussion started by: vivekshankar
2 Replies
Login or Register to Ask a Question