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
cubrid_field_type
CUBRID_FIELD_TYPE(3) 1 CUBRID_FIELD_TYPE(3)
cubrid_field_type - Return the type of the column corresponding to the given field offset
SYNOPSIS
string cubrid_field_type (resource $result, int $field_offset)
DESCRIPTION
This function returns the type of the column corresponding to the given field offset. The returned field type could be one of the follow-
ing: "int", "real", "string", etc.
PARAMETERS
o $result
-Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
o $field_offset
- The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also
issued.
RETURN VALUES
Type of the column, on success.
FALSE when invalid field_offset value.
-1 if SQL sentence is not SELECT.
EXAMPLES
Example #1
cubrid_field_type(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$result = cubrid_execute($conn, "SELECT * FROM code");
$col_num = cubrid_num_cols($result);
printf("%-15s %-15s %s
", "Field Table", "Field Name", "Field Type");
for($i = 0; $i < $col_num; $i++) {
printf("%-15s %-15s %s
",
cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i));
}
cubrid_disconnect($conn);
?>
The above example will output:
Field Table Field Name Field Type
code s_name char
code f_name varchar
PHP Documentation Group CUBRID_FIELD_TYPE(3)