Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Qshell output to excel

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Qshell output to excel
# 1  
Old 03-05-2012
Qshell output to excel
Hi all,

I hope this is the right topic for this issue.

I made a list with directories, files, size, ... and i want to export it to a .CSV file.
He does creat my .csv file that i'm asking but i can't read anything of it.
It is all weird symbolics etc. Even when i make a .txt file.
Any help?

For example:
Code:
…@aˆ–”…a@ó÷ô%`…@aˆ–”…aaÕÓÅæÉ@ò%`…@aˆ–”
…aa¤•‰ƒ–”@ô%`…@aˆ–”…aa¤•‰ƒ–”a“‰ƒ…•¢…¢@ô%`
…@aˆ–”…aa¤•‰ƒ–”a“‰ƒ…•¢…¢aÉÁÁ@ð%`…@aˆ–”…a
a¤•ƒ–”a“ƒ…•¢…¢aÉÃÁ@ñ%`…@aˆ–”…aa¤•‰ƒ–”a“ƒ…•¢…¢aÉÔÁ@ð%`…
@aˆ–”…aa¤•ƒ–”a“ƒ…•¢…¢aÉ×Á@ð%`…@aˆ–”…aa¤•‰ƒ–”a“ƒ…•¢…¢aÉâÁ@ñ%`…@aˆ–”…aa¤•ƒ–”a“ƒ…•¢…¢aâ
ÄÁ@ò%`…@aˆ–”…aa¤•‰ƒ–”a“ƒ…•¢…¢aâÉÁ@ð%`…@aˆ–”…aaÔÔÉâÅ
äÙ@ø%`…@aˆ–”…aaÙÂÖââÅÕâ@ð%`…@aˆ–”…aaÙÄÅæÉããÅ@ñø%`…@aˆ
–”…aaÙÄÅæÉããÅaÅÖÄãÅâã@ò%`…@aˆ–”…aaÒÈÁÙÄè@ð%`…@aˆ–”…aaÄÔÁã
ãÈèâ@òð%`…@aˆ–”…aaÄÔÁããÈèâaK…ƒ“‰—¢…@ð%`…@aˆ–”…aaÄÔÁããÈèâaK…ƒ“‰

# 2  
Old 03-05-2012
Qshell is not AIX or a normal Shell, but somebody here might know it.

What do you type to create the file?
What did you type to try to read the file?
# 3  
Old 03-05-2012
Thanks for the quick respons methyl but unfortunately i'm not at work anymore.
I'll let you know the right command tomorrow.
# 4  
Old 03-07-2012
Methyl,

I typed
Code:
for x in `find /home/ -type d`; do echo -e "$x \c"; find $x -type f | grep -vc "^$x/[^/]*/.*"; done > /home/nboghman/list.csv

and this output i want to be able to read in excel.
I do open the file in excel itself.

Any idea?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

For loop output to excel file

Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help? The output which I get Server1 : count... (1 Reply)
Discussion started by: srilaxman
1 Replies

2. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

3. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies

4. Shell Programming and Scripting

Excel table like output with printf

Hi All; I try to create a excel like table with headers and some fields containing values, other long and complex mathematic formulas. I have some header like : Name Formula Value True/False Under name column, they are some formula names, formula column some long mathematic formulas... (9 Replies)
Discussion started by: reseki
9 Replies

5. Shell Programming and Scripting

Redirect the output to different worksheet in excel

Hi, I need to redirect of a script to different worksheet in a single excel file. I have four queries in that script. Each query output needs to be placed in separate worksheet of a excel file. can someone help me to find this? (10 Replies)
Discussion started by: Arasu
10 Replies

6. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

7. Shell Programming and Scripting

Script to parse TOP output for Excel

I'd like to parse TOP output file containing data like the below, and then be able to import the parsed file in to Excel where I can easily generate graphs. Ideally, the output would have a single column for each value in the output. Any thoughts on how to get started with this, or a better... (3 Replies)
Discussion started by: NoMasVentanas
3 Replies

8. Shell Programming and Scripting

Help to get the Output of PL/SQL procedure In a Excel or Text File

Hi, Could anyone please guide me to get the output of the PL/SQL procedure in a Excel file or Text File... Thanks (1 Reply)
Discussion started by: funonnet
1 Replies

9. Windows & DOS: Issues & Discussions

Output Of FIND command in dos to Excel File.

Hi I want to export DOS output of find command in Excel. However I want information to be in different column and not in same. I am using this command set /p String_to_search='Enter String to search !' set /p File_to_search='Enter File to search !' findstr /N "%String_to_search%"... (0 Replies)
Discussion started by: dashing201
0 Replies

10. Shell Programming and Scripting

oracle query output in excel file

Hi All, I have seen many examples of spooling query output in csv file. But I want to spool the query results in proper excel file. Can you guys help me on this? (4 Replies)
Discussion started by: yabhi_22
4 Replies
Login or Register to Ask a Question