Redirect Standard output and standard error into spreadsheet


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Redirect Standard output and standard error into spreadsheet
# 1  
Old 05-05-2010
Redirect Standard output and standard error into spreadsheet

Hey, I'm completely new at this and I was wondering if there is a way that I would be able to redirect the log files in a directories standard output and standard error into and excel spreadsheet in anyway?

Please remember don't use too advanced of terminology as I just started using shell scripts yesterday for the first time.

Thank you!

you're fellow shell noob!
# 2  
Old 05-05-2010
It's a lot easier to make a CSV file than a proper spreadsheet, and Excel can understand them just fine. A CSV file is just a text file of the form:

Code:
column1,column2,column3,column4
row1data1,row1data2,row1data3,row1data4
row2data1,row2data2,row2data3,row2data4
...

As for how to do it, that depends entirely on what you're trying to turn into what.
# 3  
Old 05-06-2010
Well within a directory we have a bunch of log files of data. I would like to store by date and significancy? How do i even start the shell command to access the log files and place them in a csv file?



Quote:
Originally Posted by Corona688
It's a lot easier to make a CSV file than a proper spreadsheet, and Excel can understand them just fine. A CSV file is just a text file of the form:

Code:
column1,column2,column3,column4
row1data1,row1data2,row1data3,row1data4
row2data1,row2data2,row2data3,row2data4
...

As for how to do it, that depends entirely on what you're trying to turn into what.
# 4  
Old 05-06-2010
can you post the sample date and the expected csv file format??
# 5  
Old 05-06-2010
when listing them by ls -l i get something along these... expect more this is just a sample


drwxr-xr-x 2 kram kram 4096 2010-03-22 16:08 P2_XXXX76_PXXXXX4_G
drwxr-xr-x 2 kram kram 4096 2010-03-22 16:51 P2_OK7976_PK96285_G
drwxr-xr-x 3 kram kram 4096 2010-03-17 12:03 P2_OK9988_PKXXXX7_
drwxr-xr-x 3 kram kram 4096 2010-03-17 11:50 P2_OK9988_XX1XXX7_


Now with all these values i'd like to creat a spreadsheet shows wat data and the time and in what directory as we could see the date and time as well as the directory there
# 6  
Old 05-06-2010
can you please provide a simple o/p format.. i mean how it should look
# 7  
Old 05-06-2010
We really need to know what exactly you're doing here. There's not a turn_generic_logfile_into_excel_spreadsheet.exe that'll psychically know how to break your logfiles into spreadsheet cells then feed it into excel. We're trying to help you write a shell script based on what you do know about your data. Depending on what it is, it could be very easy or quite complex.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Redirect Standard Error to /dev/null is not working.

Hello. When I run a .ksh that contains the command below, and there is no file available in the source location the "FILE_NAME_*.CSV not found" error is still being displayed. FILEN=$(ssh ${SOURCE_SERV} "cd ${SOURCE_LOCATION} ;ls ${FILES}") 2> /dev/null. This is interfering with the rest... (4 Replies)
Discussion started by: jimbojames
4 Replies

2. Shell Programming and Scripting

How redirect standard output to a file

Hi guys, i have a script named purgeErrors.ksh, when i execute this script i need to redirect the output to a log file in the same directory, how can i do that ?? -- Aditya (5 Replies)
Discussion started by: chaditya
5 Replies

3. UNIX for Dummies Questions & Answers

Standard error output to Pipe input - solved

Hi, I want to check a particular word is in standard error output or not. Can I acheive it in single command? For example, Delete file_name 2>error.log cat error.log Output: XXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXX Successfully deleted XXXXXXXXXXXXXXXXX where delete is... (2 Replies)
Discussion started by: poova
2 Replies

4. Shell Programming and Scripting

Redirect standard error to input of other process, 2| ?

Hello, I would like to know if there is a shell in which operations such as 2| (redirect standard error of one process to the standard input of another one) exist? I know it is possible to do it in bash with things like: (process 2>&1) | other_process but I find it a bit intricate when... (3 Replies)
Discussion started by: chlorine
3 Replies

5. Shell Programming and Scripting

standard error to standard out question

Hi there how can i get the result of a command to not give me its error. For example, on certain systems the 'zfs' command below is not available, but this is fine becaues I am testing against $? so i dont want to see the message " command not found" Ive tried outputting to /dev/null 2>&1 to no... (5 Replies)
Discussion started by: hcclnoodles
5 Replies

6. Programming

Redirect Standard Output Multi-Process

Hi, I'm trying to compile the following code: /************** Begin <test.c> ***************/ /* * Compiled with: gcc -Wall -o test test.c */ #include <stdio.h> #include <unistd.h> int main(void) { printf("I'm process %d, son of %d \n", getpid(), getppid()); ... (5 Replies)
Discussion started by: djodjo
5 Replies

7. Shell Programming and Scripting

[BASH] redirect standard error and use it inside

Hi all, Maybe my question is too simple but till now i couldn't figure about a solution :( I have a bash script scheduled in cron: <cron time parameters> my_script.sh > result.log 2>&1 By this way i can have standard output and standard error in my result.log file Now i want my script... (2 Replies)
Discussion started by: Pescator
2 Replies

8. Shell Programming and Scripting

redirect only the standard error output to mail

I'm writing a script using file descriptor 2 (std error) to send an email only if the command fails or errors out but the script always emails me irrepective of whether it fails or not. It will not email the /tmp/check.error file output if doesn't error out just the mail with the subject "Cannot... (3 Replies)
Discussion started by: barkath
3 Replies

9. UNIX for Dummies Questions & Answers

Question from a newbie. How to redirect standard output

I have a program that is sending error text to the console and I need to redirect that output to a log file. I'm brand new to Unix and don't know how to do this. Any direction would be greatly appreciated. (1 Reply)
Discussion started by: ndemos
1 Replies

10. UNIX for Dummies Questions & Answers

redirect standard error into log file

Hi, I am new in shell scripting. Can anyone point out what wrong of below script. If I want the error output to "sqlerror.log" and database pool data output to "bulk_main.dat". Right now, the below script, if successful execute, the data will output to bulk_main.dat && sqlerror.log both... (7 Replies)
Discussion started by: epall
7 Replies
Login or Register to Ask a Question

Featured Tech Videos