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
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
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
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
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
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
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
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
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
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
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
sqlite_column
SQLITE_COLUMN(3) SQLITE_COLUMN(3)
sqlite_column - Fetches a column from the current row of a result set
SYNOPSIS
mixed sqlite_column (resource $result, mixed $index_or_name, [bool $decode_binary = true])
DESCRIPTION
mixed SQLiteResult::column (mixed $index_or_name, [bool $decode_binary = true])
mixed SQLiteUnbuffered::column (mixed $index_or_name, [bool $decode_binary = true])
Fetches the value of a column named $index_or_name (if it is a string), or of the ordinal column numbered $index_or_name (if it is an
integer) from the current row of the query result handle $result.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
o $index_or_name
- The column index or name to fetch.
o $decode_binary
-When the $decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it
was encoded using the sqlite_escape_string(3). You should normally leave this value at its default, unless you are interoperating
with databases created by other sqlite capable applications.
RETURN VALUES
Returns the column value.
NOTES
Note
Use this function when you are iterating a large result set with many columns, or with columns that contain large amounts of data.
SEE ALSO
sqlite_fetch_string(3).
PHP Documentation Group SQLITE_COLUMN(3)