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...
Could any body give some idea on this for the above code...
I need the result in different column.
Delimit the $8 and $9 fields by a comma.
Sorry..
i didnt get you man..
could you please help me out again..
Shahul
August 8, 2008, 12:25pm
4
Hi,
can you given me the view of output that you have...so that hope i can try...
Shahul
August 8, 2008, 12:32pm
5
Hope the below is the one which shamrock said...correct me if am wrong..
if your output looks like below.
columnA columnB
the above output is present in file1.txt
then just use the below command to make it csv
sed 's/space/,/g' file1
it should give the output like below
or if there are two different column in differnt files then you can use the below command
paste -d, file1 file2 > output.csv
thanks
2008/home/ADMIN/om/1.txt
2008 /home/ADMIN/om/1.txt
This part will come in A column
2008
the below part will come in column B
Shahul
August 8, 2008, 12:57pm
9
please try the below one..and let me know
if the directory start with /home only then please use the below one
sed 's:/:,/home:g' file1.txt > output.csv
let me know if this is working
Thanks
Shahul
August 8, 2008, 1:05pm
10
please try the below one..and let me know
if the directory start with /home only then please use the below one
sed 's:/:,/home:g' file1.txt > output.csv
Thanks
Shahul
August 8, 2008, 1:14pm
11
small change..
that should be..
sed 's:/home:,/home:g' file1.txt > output.csv
