Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Excel related query for the code..need help..
Top Forums Shell Programming and Scripting Excel related query for the code..need help.. Post 302223099 by sapan123 on Friday 8th of August 2008 10:32:36 AM
Old 08-08-2008
Excel related query for the code..need help..
find /A/B/C/{1,3,5,7} -name "*.txt" -o -name "*.csv" -o -name "*.TXT" -o -name "*.dat" |xargs ls -ltr |awk '{print $8 ,$9}' > result.xls

it will give the result that is $8 and &9 in the result file...
let say i need the result is a excel file....and i need the result to be print like $8 field should be in the column A and $9 should be print in the B column of in the excel file..

Could any body give some idea on this for the above code...
the above code is giving the result in the column A.

I need the result in different column.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Query related to #!/bin/sh

hi All Why is #!/bin/sh being used in most of the ksh scripts......? I have seen this (#!/bin/sh) being used at the start of the script Regards Suresh (2 Replies)
Discussion started by: sureshg_sampat
2 Replies

2. Shell Programming and Scripting

sed related query

Hi I have a file which looks like this //string = "abcd"; //info //string = "*pqrs"; //add string = "#123"; //sub //string = "#1234567890" data = check(string) //string = "#1234567890" I want to modify this as string = "#987"; //mult data = check(string) How do i do that? (1 Reply)
Discussion started by: gopsman
1 Replies

3. UNIX for Dummies Questions & Answers

awk related query

hi, I have to extract a column from a file and then updated that column..?? Now i can use wak for extracting it and then how to update it.. $ awk' {print $5}' input_file Can i use sed command here piping it to the output from the awk command.. (2 Replies)
Discussion started by: abhisek.says
2 Replies

4. Shell Programming and Scripting

Print related query

i Am using the below query and printing the $8 and $9 filed.. find /A/B/C/{1,3,5,7} -name "*.txt" -o -name "*.csv" -o -name "*.TXT" -o -name "*.dat" |xargs ls -ltr |awk '{print $8 ,$9}' > result.xls this give me the rsult like below.. 2008/home/ADMIN/om/1.txt 2008/home/ADMIN/om/hi.txt ... (1 Reply)
Discussion started by: sapan123
1 Replies

5. Shell Programming and Scripting

query related to if

wht does below statement mean? if wht does dis -d option do?? TIA. (1 Reply)
Discussion started by: sainathdeg
1 Replies

6. Shell Programming and Scripting

datetimestamp related query!

Hi all, I have put a query in a thread but didn't get any reply. Hoping to get a reply here. I have a file in that one line resembles like below... Forwarded by Deepak on 11/15/2009 10:28 AM EST ofcourse AM can be PM also... so what i need is first i need to get only... (1 Reply)
Discussion started by: smarty86
1 Replies

7. Solaris

Query related to runlevels and milestones

Hi friends.. Please clarify my follg doubts: 1. I can easily switch from runlevel 1 to runlevel 2 or 3 by means of init 2 or init 3 commands. I can even get a gui login screen when i do an init 3 from runlevel1. 2.But suppose if I am in GUI and switched to single-user milestone by means of ... (3 Replies)
Discussion started by: saagar
3 Replies

8. UNIX for Dummies Questions & Answers

A query related to 'ls' command

I am executing the ls command to show the contents of a folder, it shows some number in front of word total as highlighted in blue color below quotes. Can anyone please share that what it is? (2 Replies)
Discussion started by: Zaib
2 Replies

9. UNIX for Dummies Questions & Answers

query related to grep

Hi All, The result for 'grep "cert_codes" /develop/sales/appl.srce/*.4gl' command will be saved at aa.txt grep "cert_codes" /develop/sales/appl.srce/*.4gl >aa.txt But I am not sure, whether, all result stored in .txt file in case of multi-line result. Please revert back if... (2 Replies)
Discussion started by: pbankar
2 Replies

10. Emergency UNIX and Linux Support

Interfaces related query

I need to list the interfaces that uses FTP instead of SFTP on my applications that are on AIX servers. How do I get that list of IP addresses that connect to my applications via FTP? (2 Replies)
Discussion started by: ggayathri
2 Replies

LEARN ABOUT PHP

db2_field_precision

DB2_FIELD_PRECISION(3)							 1						    DB2_FIELD_PRECISION(3)

db2_field_precision - Returns the precision of the indicated column in a result set

SYNOPSIS

       int db2_field_precision (resource  $stmt, mixed	$column)

DESCRIPTION

	Returns the precision of the indicated column in a result set.

PARAMETERS

	      o $stmt
		- Specifies a statement resource containing a result set.

	      o $column
		-  Specifies  the  column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
		string containing the name of the column.

RETURN VALUES

	Returns an integer containing the precision of the specified  column.  If  the	specified  column  does  not  exist  in  the  result  set,
       db2_field_precision(3) returns FALSE.

SEE ALSO

       db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3).

PHP Documentation Group 												    DB2_FIELD_PRECISION(3)
All times are GMT -4. The time now is 09:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy